http://snipplr.com/users/pollusb/tags/tsql Recent snippets posted on Snipplr.com en-us Wed, 15 Feb 2012 10:03:15 GMT http://snipplr.com/view/13485/extract-logins-default-db/ Extract logins default db settings from one server to export to another

]]> Thu, 26 Mar 2009 13:26:18 GMT http://snipplr.com/view/13485/extract-logins-default-db/ 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/