AJAYVISHU
Ad Unit (Iklan) BIG
AJAYVISHU
Home
Features
_Multi DropDown
__DropDown 1
__DropDown 2
__DropDown 3
_ShortCodes
_SiteMap
_Error Page
Learn Blogging
Documentation
_Web Documentation
_Video Documentation
ABOUT US
Home
sql
how to get all column from table than set comma seperate in sql
how to get all column from table than set comma seperate in sql
ajayvishu
November 06, 2019
select string_agg(name,',') name from sys.columns where object_id = object_id('dbo.tablename')
output :
col1,col2,col3
Post a Comment
0 Comments
Search This Blog
Software Developer
ajayvishu
View my complete profile
2019
42
2020
53
Category
ajax
2
api
8
asp.net core
3
asp.net mvc
10
browser
1
c#
17
command prompt
14
google map
2
iis
1
javascript
14
jquery
19
linq
1
live server
5
node js
5
php
1
security
3
signalr
1
sql
21
visual code
2
windows os
10
Social Plugin
Popular Posts
calculate code execution time in asp.net mvc
July 01, 2020
how to connect database in asp.net web pages with sql server
June 21, 2020
how to enable ultimate performance mode in windows 10
July 13, 2020
offline setup download of visual studio 2019
July 13, 2020
maximum sum of subarray
May 30, 2020
0 Comments