SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by DBLACKWELL / SQL Script to generate columns for triggers / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 13:08:12 GMT20RE: SQL Script to generate columns for triggershttp://www.sqlservercentral.com/Forums/Topic1039213-2877-1.aspxread many time still don't understand what are you talking about. Which is your resutls ? copy paste what???Fri, 14 Jan 2011 17:01:35 GMTjiaoxgRE: SQL Script to generate columns for triggershttp://www.sqlservercentral.com/Forums/Topic1039213-2877-1.aspxOr, Just drag the Columns node from the object browser into the Query editor.Tue, 04 Jan 2011 17:25:00 GMTstarunitRE: SQL Script to generate columns for triggershttp://www.sqlservercentral.com/Forums/Topic1039213-2877-1.aspx[code="sql"]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[/code]Mon, 27 Dec 2010 15:46:09 GMTfahey.jonathanSQL Script to generate columns for triggershttp://www.sqlservercentral.com/Forums/Topic1039213-2877-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/T-SQL/71891/">SQL Script to generate columns for triggers</A>[/B]Sat, 25 Dec 2010 12:30:19 GMTDBLACKWELL