Snipplr http://snipplr.com/language/sql/tags/sqlserver Recent snippets posted on Snipplr.com en-us Tue, 21 May 2013 23:15:38 GMT (SQL) Reset Identity - indra http://snipplr.com/view/58889/reset-identity/

]]> Wed, 21 Sep 2011 15:52:30 GMT http://snipplr.com/view/58889/reset-identity/ (SQL) SQL Server Restore Progress - beaknit http://snipplr.com/view/56749/sql-server-restore-progress/

]]> Mon, 18 Jul 2011 14:01:35 GMT http://snipplr.com/view/56749/sql-server-restore-progress/ (SQL) Lots of Table Info - michanne http://snipplr.com/view/55040/lots-of-table-info/ SQL Server - everything you want to know (or not) about a table.

]]> Thu, 09 Jun 2011 03:35:08 GMT http://snipplr.com/view/55040/lots-of-table-info/ (SQL) Sample Table Sample - michanne http://snipplr.com/view/53263/sample-table-sample/ Alternate to tablesample clause. Example from BOL "The expression CAST(CHECKSUM(NEWID(), SalesOrderID) & 0x7fffffff AS float / CAST (0x7fffffff AS int) evaluates to a random float value between 0 and 1"

]]> Tue, 10 May 2011 04:18:38 GMT http://snipplr.com/view/53263/sample-table-sample/ (SQL) Kill Connections to SQL Server - tclancy http://snipplr.com/view/51617/kill-connections-to-sql-server/

]]> Wed, 06 Apr 2011 01:02:50 GMT http://snipplr.com/view/51617/kill-connections-to-sql-server/ (SQL) SQL Server SP/FN Set Options - michanne http://snipplr.com/view/50564/sql-server-spfn-set-options/

]]> Sat, 12 Mar 2011 07:34:14 GMT http://snipplr.com/view/50564/sql-server-spfn-set-options/ (SQL) SQL Server - Find text in stored proc - SkyeBianca http://snipplr.com/view/45332/sql-server--find-text-in-stored-proc/

]]> Mon, 06 Dec 2010 11:48:22 GMT http://snipplr.com/view/45332/sql-server--find-text-in-stored-proc/ (SQL) Conditional Where Criteria - indra http://snipplr.com/view/42517/conditional-where-criteria/

]]> Tue, 19 Oct 2010 05:19:23 GMT http://snipplr.com/view/42517/conditional-where-criteria/ (SQL) Show User Table-Func-Sp - indra http://snipplr.com/view/39457/show-user-tablefuncsp/

]]> Tue, 24 Aug 2010 14:11:43 GMT http://snipplr.com/view/39457/show-user-tablefuncsp/ (SQL) Find First and Last Day of Current Month - indra http://snipplr.com/view/39454/find-first-and-last-day-of-current-month/

]]> Tue, 24 Aug 2010 13:37:53 GMT http://snipplr.com/view/39454/find-first-and-last-day-of-current-month/ (SQL) SQL Searh And Replace in ALL DataBase - Eloi http://snipplr.com/view/37010/sql-searh-and-replace-in-all-database/ Stored Procedure for search and replace a string in all fields of all tables of one DataBase

]]> Fri, 09 Jul 2010 21:54:31 GMT http://snipplr.com/view/37010/sql-searh-and-replace-in-all-database/ (SQL) SQL Searh in ALL DataBase - Eloi http://snipplr.com/view/37009/sql-searh-in-all-database/ Stored Procedure for search a string in all fields of all tables of one DataBase

]]> Fri, 09 Jul 2010 21:47:17 GMT http://snipplr.com/view/37009/sql-searh-in-all-database/ (SQL) Search stored procedures for string - charmcitycoder http://snipplr.com/view/17527/search-stored-procedures-for-string/

]]> Mon, 27 Jul 2009 15:37:23 GMT http://snipplr.com/view/17527/search-stored-procedures-for-string/ (SQL) SQL Server truncate log and shrink file - robe http://snipplr.com/view/10370/sql-server-truncate-log-and-shrink-file/

]]> Wed, 10 Dec 2008 02:55:00 GMT http://snipplr.com/view/10370/sql-server-truncate-log-and-shrink-file/ (SQL) SQL Server Split function - robe http://snipplr.com/view/10278/sql-server-split-function/

]]> Fri, 05 Dec 2008 01:09:54 GMT http://snipplr.com/view/10278/sql-server-split-function/ (SQL) Check column existence - Elph http://snipplr.com/view/8684/check-column-existence/ Comprobar si una columna existe en una determinada tabla

]]> Mon, 29 Sep 2008 06:51:08 GMT http://snipplr.com/view/8684/check-column-existence/