SQLServerCentral.com Scripts tagged T-SQL

Run SQL code on each database

Wed, 10 Apr 2013 06:00:00 UT

You can use this to run a script/s on multiple databases

Backup all SSAS databases using TSQL

Thu, 28 Mar 2013 06:00:00 UT

Enumerates and backups all SSAS DB's

Copy Sql Objects

Fri, 29 Mar 2013 06:00:00 UT

Copy tables, procedures, functions and view from one schema and another schema.

Copy Table

Wed, 03 Apr 2013 06:00:00 UT

Copy tables from one schema to another schema.

Create Table with T-SQL

Mon, 01 Apr 2013 06:00:00 UT

Generate create table statement using T-SQL.

Converting to datetime a char field with several possible date formats

Thu, 21 Feb 2013 07:00:00 UT

Converting to datetime a char field having several possible date formats

Transpose Query Output

Fri, 22 Feb 2013 07:00:00 UT

script to return query result transposed.

Get Database Size

Mon, 18 Feb 2013 07:00:00 UT

Know you database size

Open transactions on a database

Wed, 30 Jan 2013 07:00:00 UT

This script will show you all open transactions from any query windows.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

T-SQL Bulk Insert

Thu, 07 Feb 2013 07:00:00 UT

T-SQL that allows you to import tab delimited text file into correct table based on file name.

Number of Working Days

Fri, 08 Feb 2013 07:00:00 UT

Number of workings days in a month minus weekends and holidays.

Print Text Month Calendar

Thu, 29 Nov 2012 07:00:00 UT

This function return the text format of a month calendar. It could be useful for sending through emails when you do do not have other tools, but T-SQL to send text emails.

Deleting Duplicate Records

Tue, 20 Nov 2012 07:00:00 UT

In Datawarehousing, a normal scenario is eleminating duplicate records/rows or deleting duplicate records, here's the solution.

SCD Implementation with TSQL

Tue, 13 Nov 2012 07:00:00 UT

ETL for a SCD using only TSQL, without hash functions

Create A Folder With T-SQL

Tue, 16 Oct 2012 06:00:00 UT

Pass a folder name to this SP and it will create the folder for you.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

Print The Calendar 2

Fri, 10 Aug 2012 06:00:00 UT

This script will print the calendar from the given date.

Calculate alphabetic sequence

Wed, 08 Aug 2012 06:00:00 UT

This simple function allows to calculate a code sequence of letters. AAA, AAB, AAAC, ADF, .... AAZ, ABA, ABC, ... ZZZ

Check Used Table Space for User Defined Tables

Wed, 11 Jul 2012 06:00:00 UT

Query the System Tables to find the space usage, which helps Database Administrators identify the Tables that are using the most space.

Use your own optimizer to tune queries

Thu, 07 Jun 2012 06:00:00 UT

Use your own optimizer to tune queries

Get a range of numbers

Fri, 05 Oct 2012 06:00:00 UT

If you need to get a range sequence of numbers this script can help you to acomplish it. For example : the sequency of numbers between -5 and 5 or 1 and 200, etc..

Swiss Cheese!

Thu, 26 Apr 2012 06:00:00 UT

Are you trying to determine the gaps in a numerical sequence?

Did you say denormalize, why?

Wed, 25 Apr 2012 06:00:00 UT

How to display data from 1-to-many in a single record!

Script to get database restore history

Fri, 16 Mar 2012 06:00:00 UT

T-SQL to get restore history of SQL databases.

Split Function to break the Job History Message into a Table

Thu, 22 Mar 2012 06:00:00 UT

Split Function for T-SQL Server to break the Job History Message into Table.

Select the last error in the job selected

Thu, 15 Mar 2012 06:00:00 UT

The job will send an HTML email with the latest error at specific job.

TSQL fast unix timestamp conversion

Fri, 02 Dec 2011 07:00:00 UT

How to convert Unix timestamp into datetime taking into account also summer or winter time

Compare 2 datasets and output delta in one TSQL statement

Fri, 04 Nov 2011 06:00:00 UT

There are many ways 2 compare datasets to find differences, this is one of them.

who can do what?

Mon, 31 Oct 2011 06:00:00 UT

list each user has the right to do

Different ways to write Distinct Query - MSSQL

Tue, 01 Nov 2011 06:00:00 UT

Distinct Query

search and replace a string in all user tables’ data in all databases

Thu, 10 Nov 2011 07:00:00 UT

This script will search for the input string in all the tables(data) from all the databases and will generate a script that will replace the searched string with the required string passed