http://snipplr.com/users/pollusb/tags/dev Recent snippets posted on Snipplr.com en-us Wed, 22 May 2013 10:16:38 GMT http://snipplr.com/view/13451/spcoldefinition-or-writing-upsert-sp-in-a-snap/ sp_ColDefinition will use the metadata tables to create a table result that looks like this : DECLARE --------------------- @title_id varchar(6), @title varchar(80), @type char(12), @pub_id char(4), @price money, @advance money, @royalty int, @ytd_sales int, @notes varchar(200), @pubdate datetime(8),

]]> Wed, 25 Mar 2009 22:17:48 GMT http://snipplr.com/view/13451/spcoldefinition-or-writing-upsert-sp-in-a-snap/