Viewing 3 posts - 1 through 4 (of 4 total)
I have written query to drop column when it is not need, so that only I mentioned unstable column.
October 15, 2012 at 3:13 am
#1549034
I have to display unstable column from database, that's why I need like that.
Can you post sample dynamic SQL procedure?
October 15, 2012 at 2:58 am
#1549027
Thank you for your reply,
SELECT SUBSTRING ( (SELECT ', ' +'['+ Name+']' FROM sys.columns WHERE object_name(object_id) = 'emp_details' ORDER BY object_id FOR XML PATH('')), 2,100)
Using this query am getting a...
October 15, 2012 at 12:57 am
#1548998