cnranasinghe
.NET / ASP.NET / SQL Server / Developer Express
Total Pageviews
Wednesday, September 1, 2010
List SQL table column as rows
use TestDB
select COLUMN_NAME 'All_Columns' from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='tblTest'
1 comment:
Dinindu Fernando
September 10, 2010 at 4:21 AM
great !
Reply
Delete
Replies
Reply
Add comment
Load more...
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
great !
ReplyDelete