//Sql Query
DECLARE @ColStr VARCHAR(MAX)
SELECT @ColStr = COALESCE(''+@ColStr +',' ,'') +'['+ name+']' FROM sys.columns where object_name(object_id)='TableName'
Print @ColStr
// Result
[Active],[StateCode],[StateName]
–> To highlight a block of code in Notepad++, please do the following steps step-1 :- Select the required text. step-2 :- Right click...
No comments:
Post a Comment