Snipplr

(SQL) Auto Incremementing Id for Insert in T-SQL table - ezerick

Tue, 20 Dec 2011 04:28:54 UTC

This code allows you to create an ID field value for inserts into a table that does not auto increment itself

(SQL) Fox XML in TSQL - ezerick

Wed, 02 Nov 2011 05:22:23 UTC

(SQL) T-SQL Function to convert Unix Timestamp into MS SQL datetime Â« ProgAdv - ezerick

Fri, 08 Jul 2011 05:09:28 UTC

(SQL) Delete duplicate rows from the table using row_number() - SQLServerCentral - ezerick

Wed, 06 Jul 2011 00:29:04 UTC

(SQL) Function to split a list into a table in T-SQL - ezerick

Tue, 21 Jun 2011 23:24:13 UTC

(SQL) Relevance-based Site Search with SQL | JarrodGoddard.com - ezerick

Sat, 12 Mar 2011 08:37:58 UTC

(SQL) Search for a text in all databases - SQLServerCentral - ezerick

Thu, 03 Mar 2011 08:07:05 UTC

(SQL) Find Duplicate Rows in Table - ezerick

Sat, 22 Jan 2011 04:47:21 UTC

Field1 + Field2 + Field3 should create 1 entry for each unique row in the DB. In an employee table, this would be FirstName + LastName + EmployeeNumber

(SQL) How to search all columns of all tables in a database for a keyword - ezerick

Sat, 16 Oct 2010 01:07:32 UTC

(SQL) Find a search string in stored procedures -TSQL - ezerick

Sat, 09 Oct 2010 07:32:48 UTC

(SQL) SQL Server 2005 - All Cols in all Tables in a DB - ezerick

Wed, 23 Jun 2010 05:08:26 UTC

(SQL) Find all Foreign Keys in a SQL Server DB - ezerick

Thu, 17 Jun 2010 00:54:48 UTC

(SQL) TSQL - Find All Empty Columns in a Database - ezerick

Fri, 26 Mar 2010 11:32:09 UTC

I found this and simply want to store it. It was done by Valentino Vranken