Snipplr

(SQL) Enable Ad Hoc Distributed Queries using sp_configure - jprochazka

Wed, 27 Mar 2013 03:49:23 GMT

Allows Ad Hoc Distributed Queries using by executing sp_configure.

(SQL) SQL Server: Remove extra spaces from a string. - jprochazka

Fri, 21 Dec 2012 23:08:08 GMT

Removes extra spaces from a string in SQL Server.

(SQL) Microsoft SQL Server: Back up all transaction logs. - jprochazka

Tue, 06 Nov 2012 08:14:25 GMT

Backs up all database transaction logs within a Microsoft SQL Server instance except for databases set to simple recovery mode.

(SQL) Microsoft SQL Server: Back up all databases. - jprochazka

Tue, 06 Nov 2012 08:11:50 GMT

Backs up all databases contained in a Microsoft SQL Server instance.

(PL/SQL) MSSQL Cursor - simi23

Wed, 11 Jan 2012 22:52:59 GMT

basic definition for a cursor in MSSQL

(SQL) MS SQL - Select Seed, Increment and Current Identity Values - SocialCocoa

Thu, 03 Nov 2011 03:38:55 GMT

Thanks to Pinal Dave (http://blog.SQLAuthority.com).

(SQL) Restore MSSQL database from backup (.bak) - plugables

Tue, 06 Sep 2011 21:28:46 GMT

(SQL) Mssql update or insert - icebob

Wed, 17 Aug 2011 22:08:12 GMT

(SQL) Mssql indexinfo - icebob

Wed, 17 Aug 2011 21:43:03 GMT

(SQL) MSSQL get missing index list - icebob

Wed, 17 Aug 2011 21:38:42 GMT

(SQL) Microsoft SQL Server: Rename a database schema. - jprochazka

Sat, 13 Aug 2011 01:15:34 GMT

Generates a set of queries to run which will change the schema for all items within a specified schema and change them to another.

(SQL) Paginating Data - BenJD

Wed, 29 Jun 2011 16:17:36 GMT

(SQL) Count number of tables, views, stored procedures or functions - Mithun

Wed, 04 May 2011 19:11:45 GMT

You can use TSQL to Count Number Of Stored Procedures, Views, Tables or Functions in a Database by using the Database INFORMATION_SCHEMA view

(C#) Method to import MySQL Scripts to MS SQL - Krummelz

Tue, 15 Mar 2011 19:58:16 GMT

it ignores commas in a csv that are in string quotes

(SQL) DATETIME Convert UTC to Local - davidrodriguez

Fri, 11 Feb 2011 09:59:35 GMT

How to convert a column of DATETIME UTC to local time.

(SQL) Microsoft SQL Server: Find and replace. - jprochazka

Tue, 11 Jan 2011 06:06:09 GMT

Clears supplied text from database tables. Does not clear the string out of TEXT or NTEXT tables.

(SQL) GET MIN CD - sekihin

Wed, 04 Aug 2010 18:15:57 GMT

(SQL) Add a column in a MSSQL table - certainlyakey

Thu, 22 Jul 2010 03:39:07 GMT

(SQL) Rename a column in a MSSQL table - certainlyakey

Thu, 22 Jul 2010 03:37:34 GMT

(PHP) LoneDatabaseClass - coevolve

Fri, 05 Mar 2010 05:59:31 GMT