Snipplr

(SQL) Reset Identity - indra

Wed, 21 Sep 2011 15:52:30 GMT

(SQL) SQL Server Restore Progress - beaknit

Mon, 18 Jul 2011 14:01:35 GMT

(SQL) Lots of Table Info - michanne

Thu, 09 Jun 2011 03:35:08 GMT

SQL Server - everything you want to know (or not) about a table.

(SQL) Sample Table Sample - michanne

Tue, 10 May 2011 04:18:38 GMT

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"

(SQL) Kill Connections to SQL Server - tclancy

Wed, 06 Apr 2011 01:02:50 GMT

(SQL) SQL Server SP/FN Set Options - michanne

Sat, 12 Mar 2011 07:34:14 GMT

(SQL) SQL Server - Find text in stored proc - SkyeBianca

Mon, 06 Dec 2010 11:48:22 GMT

(SQL) Conditional Where Criteria - indra

Tue, 19 Oct 2010 05:19:23 GMT

(VB.NET) SQL2KConnect - indra

Tue, 24 Aug 2010 14:42:19 GMT

Class for access and manipulation database

(SQL) Show User Table-Func-Sp - indra

Tue, 24 Aug 2010 14:11:43 GMT

(SQL) Find First and Last Day of Current Month - indra

Tue, 24 Aug 2010 13:37:53 GMT

(SQL) SQL Searh And Replace in ALL DataBase - Eloi

Fri, 09 Jul 2010 21:54:31 GMT

Stored Procedure for search and replace a string in all fields of all tables of one DataBase

(SQL) SQL Searh in ALL DataBase - Eloi

Fri, 09 Jul 2010 21:47:17 GMT

Stored Procedure for search a string in all fields of all tables of one DataBase

(SQL) Search stored procedures for string - charmcitycoder

Mon, 27 Jul 2009 15:37:23 GMT

(Python) Read UTF-16 with NULL's, as received from the SQL Server "bcp" utility - Twain

Tue, 09 Jun 2009 09:31:07 GMT

Read a windows UTF-16 file (such as a BCP dump from SQL Server) that contains ASCII characters and occasional nulls

(C#) Set the directory (connection string) for an SQL Server Database Connection - pckujawa

Mon, 15 Dec 2008 11:59:07 GMT

This snippet is actually tested for SQL Server Compact Edition (CE) 3.5, but it will probably work for other SQL Server editions. Once you have an SQL CE db up and running, you can set the connection string to point to any directory and database by simply using the |DataDirectory| string in the dbConnectionString Property (created by default when you create the database connection) and then relocating the location to which |DataDirectory| points by calling AppDomain.CurrentDomain.SetData("DataDirectory", @"C:\Path\To\DB"). Since the dbConnectionString property appends \dbName.sdf, we leave that part off of the SetData argument. The code below sets the data directory to the common application data folder (usually C:\Documents and Settings\All Users\Application Data on winXP). It seems to work fine when invoked in the Form_Load method.

(SQL) SQL Server truncate log and shrink file - robe

Wed, 10 Dec 2008 02:55:00 GMT

(SQL) SQL Server Split function - robe

Fri, 05 Dec 2008 01:09:54 GMT

(DOS Batch) SQL Server Find Differences Between Two Tables - hoffstein

Tue, 25 Nov 2008 11:20:20 GMT

The TableDiff utility comes with SQL Server 2005 and can report differences on schema and data. The most popular feature of TableDiff is the fact that it can generate a script that you can run on the destination that will reconcile differences between the tables. Original source was a TechNet article called [Top 10 Hidden Gems In SQL Server 2005][1]. [1]: http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx "Top 10 Hidden Gems in SQL Server 2005"

(Other) SQL Server 2005 data types - hoffstein

Tue, 04 Nov 2008 15:07:09 GMT

## Exact numerics Type From To bigint -9,223,372,036,854,775,808 9,223,372,036,854,775,807 int -2,147,483,648 2,147,483,647 smallint -32,768 32,767 tinyint 255 bit 1 decimal -10^38 +1 10^38 –1 numeric -10^38 +1 10^38 –1 money -922,337,203,685,477.5808 +922,337,203,685,477.5807 smallmoney -214,748.3648 +214,748.3647 numeric and decimal are Fixed precision and scale data types and are functionally equivalent. ## Approximate numerics Type From To float -1.79E + 308 1.79E + 308 real -3.40E + 38 3.40E + 38 ## datetime and smalldatetime Type From To datetime (3.33 milliseconds accuracy) Jan 1, 1753 Dec 31, 9999 smalldatetime (1 minute accuracy) Jan 1, 1900 Jun 6, 2079 ## Character Strings Type Description char Fixed-length non-Unicode character data with a maximum length of 8,000 characters. varchar Variable-length non-Unicode data with a maximum of 8,000 characters. varchar(max) Variable-length non-Unicode data with a maximum length of 231 characters (SQL Server 2005 only). text Variable-length non-Unicode data with a maximum length of 2,147,483,647 characters. ## Unicode Character Strings Type Description nchar Fixed-length Unicode data with a maximum length of 4,000 characters. nvarchar Variable-length Unicode data with a maximum length of 4,000 characters. nvarchar(max) Variable-length Unicode data with a maximum length of 230 characters (SQL Server 2005 only). ntext Variable-length Unicode data with a maximum length of 1,073,741,823 characters. ## Binary Strings Type Description binary Fixed-length binary data with a maximum length of 8,000 bytes. varbinary Variable-length binary data with a maximum length of 8,000 bytes. varbinary(max) Variable-length binary data with a maximum length of 231 bytes (SQL Server 2005 only). image Variable-length binary data with a maximum length of 2,147,483,647 bytes.