|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 9:23 AM
Points: 88,
Visits: 221
|
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Monday, February 11, 2013 5:58 PM
Points: 100,
Visits: 347
|
|
SELECT CASE WHEN column_id = MIN(column_id) OVER(PARTITION BY 1) THEN 'INSERT INTO ' + OBJECT_NAME(object_id) + ' (' ELSE ' ' END + name + CASE WHEN column_id = MAX(column_id) OVER(PARTITION BY 1) THEN ')' ELSE ', ' END FROM sys.columns WHERE object_id = OBJECT_ID('TableName') ORDER BY column_id
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Friday, June 07, 2013 7:42 AM
Points: 103,
Visits: 2,397
|
|
Or, Just drag the Columns node from the object browser into the Query editor.
Mark Just a cog in the wheel.
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Friday, January 14, 2011 4:59 PM
Points: 1,
Visits: 0
|
|
| read many time still don't understand what are you talking about. Which is your resutls ? copy paste what???
|
|
|
|