SQLServerCentral.com Scripts tagged SQL

Manipulate Horizontal Hierarchy with UNPIVOT

Thu, 20 Dec 2012 07:00:00 UT

Convert Horizontal Hierarchy to vertical Hierarchy.

Scripting CREATE INDEX Statements Automatically From Your Tables

Tue, 27 Nov 2012 07:00:00 UT

Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.

Script to get an ordered list of all stored procedures with parameters

Tue, 14 Aug 2012 06:00:00 UT

Generate a per-schema, per-procedure ordered list of all stored procedures for the current database, together with their parameters, datatypes and nullability.

Delete old backup

Tue, 03 Jul 2012 06:00:00 UT

Delete old backup files on a prespecified folder.

How to query dBase .dbf from SQL 2012 64-bit

Wed, 09 May 2012 06:00:00 UT

Query dBase .dbf Files From SQL 2012 64-bit.