Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Reply
retrieve values from coumn name
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Vasanth Jack
7y
198
1
Reply
Hi,
I have a table in this i have to get only columns names.I got that column but now i want the values.
DECLARE @collist VARCHAR(max)='',
@sql NVARCHAR(max)
SELECT @collist += '(''' + COLUMN_NAME + ''',' + COLUMN_NAME + '),'
FROM INFORMATION_SCHEMA.columns
WHERE TABLE_NAME = 'tbl_seat'
--AND COLUMN_NAME LIKE 'Field%'
AND TABLE_SCHEMA = 'dbo'
SELECT @collist = LEFT(@collist, Len(@collist) - 1)
SET @sql ='
SELECT distinct SeatNo
FROM tbl_seat
CROSS apply (VALUES' + @collist
+ ') ca (seatno, data)
WHERE Routeid=11 and data = 0 '
EXEC Sp_executesql
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Differences between data reader and data table
Creating Database First Using EF SQL Failing