Snipplr - ezerick http://snipplr.com/users/ezerick/language/sql Recent snippets posted on Snipplr.com en-us Wed, 22 May 2013 05:50:50 GMT (SQL) Auto Incremementing Id for Insert in T-SQL table http://snipplr.com/view/61997/auto-incremementing-id-for-insert-in-tsql-table/ This code allows you to create an ID field value for inserts into a table that does not auto increment itself

]]> Tue, 20 Dec 2011 04:28:54 GMT http://snipplr.com/view/61997/auto-incremementing-id-for-insert-in-tsql-table/ (SQL) Fox XML in TSQL http://snipplr.com/view/60465/fox-xml-in-tsql/

]]> Wed, 02 Nov 2011 05:22:23 GMT http://snipplr.com/view/60465/fox-xml-in-tsql/ (SQL) T-SQL Function to convert Unix Timestamp into MS SQL datetime « ProgAdv http://snipplr.com/view/56282/tsql-function-to-convert-unix-timestamp-into-ms-sql-datetime--progadv/

]]> Fri, 08 Jul 2011 05:09:28 GMT http://snipplr.com/view/56282/tsql-function-to-convert-unix-timestamp-into-ms-sql-datetime--progadv/ (SQL) Delete duplicate rows from the table using row_number() - SQLServerCentral http://snipplr.com/view/56146/delete-duplicate-rows-from-the-table-using-rownumber--sqlservercentral/

]]> Wed, 06 Jul 2011 00:29:04 GMT http://snipplr.com/view/56146/delete-duplicate-rows-from-the-table-using-rownumber--sqlservercentral/ (SQL) Function to split a list into a table in T-SQL http://snipplr.com/view/55554/function-to-split-a-list-into-a-table-in-tsql/

]]> Tue, 21 Jun 2011 23:24:13 GMT http://snipplr.com/view/55554/function-to-split-a-list-into-a-table-in-tsql/ (SQL) Relevance-based Site Search with SQL | JarrodGoddard.com http://snipplr.com/view/50565/relevancebased-site-search-with-sql--jarrodgoddardcom/

]]> Sat, 12 Mar 2011 08:37:58 GMT http://snipplr.com/view/50565/relevancebased-site-search-with-sql--jarrodgoddardcom/ (SQL) Search for a text in all databases - SQLServerCentral http://snipplr.com/view/49964/search-for-a-text-in-all-databases--sqlservercentral/

]]> Thu, 03 Mar 2011 08:07:05 GMT http://snipplr.com/view/49964/search-for-a-text-in-all-databases--sqlservercentral/ (SQL) Find Duplicate Rows in Table http://snipplr.com/view/47690/find-duplicate-rows-in-table/ Field1 + Field2 + Field3 should create 1 entry for each unique row in the DB. In an employee table, this would be FirstName + LastName + EmployeeNumber

]]> Sat, 22 Jan 2011 04:47:21 GMT http://snipplr.com/view/47690/find-duplicate-rows-in-table/ (SQL) How to search all columns of all tables in a database for a keyword http://snipplr.com/view/42365/how-to-search-all-columns-of-all-tables-in-a-database-for-a-keyword/

]]> Sat, 16 Oct 2010 01:07:32 GMT http://snipplr.com/view/42365/how-to-search-all-columns-of-all-tables-in-a-database-for-a-keyword/ (SQL) Find a search string in stored procedures -TSQL http://snipplr.com/view/41925/find-a-search-string-in-stored-procedures-tsql/

]]> Sat, 09 Oct 2010 07:32:48 GMT http://snipplr.com/view/41925/find-a-search-string-in-stored-procedures-tsql/ (SQL) T-sql to XML http://snipplr.com/view/36096/tsql-to-xml/

]]> Thu, 24 Jun 2010 06:56:47 GMT http://snipplr.com/view/36096/tsql-to-xml/ (SQL) SQL Server 2005 - All Cols in all Tables in a DB http://snipplr.com/view/36035/sql-server-2005--all-cols-in-all-tables-in-a-db/

]]> Wed, 23 Jun 2010 05:08:26 GMT http://snipplr.com/view/36035/sql-server-2005--all-cols-in-all-tables-in-a-db/ (SQL) Find all Foreign Keys in a SQL Server DB http://snipplr.com/view/35788/find-all-foreign-keys-in-a-sql-server-db/

]]> Thu, 17 Jun 2010 00:54:48 GMT http://snipplr.com/view/35788/find-all-foreign-keys-in-a-sql-server-db/ (SQL) TSQL - Find All Empty Columns in a Database http://snipplr.com/view/30313/tsql--find-all-empty-columns-in-a-database/ I found this and simply want to store it. It was done by Valentino Vranken

]]> Fri, 26 Mar 2010 11:32:09 GMT http://snipplr.com/view/30313/tsql--find-all-empty-columns-in-a-database/