select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = 't_Customer'
Wednesday, May 11, 2011
Getting Column Name from table in SQL Server
1:57 AM
No comments
Subscribe to:
Post Comments (Atom)
Social Profiles
-
CREATE TABLE emp ( empid int, mgrid int, empname char(10) ) select * from emp INSERT emp SELECT 1,2,'Vyas' INSERT emp SELE...
-
select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 't_Customer'
-
To Generate a Random String is very Tricky and useful stuff to Know as we can use this functionality at the time of Generating Random Passwo...
-
Creating and establishing a connection with a database server is a high resource consuming process and hence by result more time taking. If...
-
If accidentally you did some CRUD operation in the table then, here I am telling how to get back to the previous stage. BEGIN TRANSACTION;...
-
With different .NET frameworks coming to existence, the usage of delegates becomes more and more desirable. To satisfy the needs .NET 3.5 ...
-
A Web Service is a program that can be invoked in a distributed web envi ronment. Web Service technologies like SOAP, WSDL, and UDDI are sta...
Download
0 comments:
Post a Comment