SQL Script to generate columns for triggers

Question

SQL Script to generate columns for triggers

DBLACKWELL

SSC Enthusiast

Points: 121
More actions
December 25, 2010 at 12:30 pm

#232298

Comments posted to this topic are about the item SQL Script to generate columns for triggers

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

fahey.jonathan Hall of Fame Points: 3617 More actions · Answer 1

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

starunit SSCommitted Points: 1817 More actions · Answer 2

Or, Just drag the Columns node from the object browser into the Query editor.

Mark
Just a cog in the wheel.

jiaoxg Grasshopper Points: 21 More actions · Answer 3

read many time still don't understand what are you talking about. Which is your resutls ? copy paste what???

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

akljfhnlaflkj

SSC Guru

Points: 76202

May 17, 2016 at 12:52 pm

#1879678

Thanks for the script.

SQL Script to generate columns for triggers

Cookies on SQLServerCentral