Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag T-SQL Rss

Search for any content tagged t-sql

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

<< Newer    Items 41 to 60 of 886    Older >>
 

Get a range of numbers

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..  Read more...
By Bernabe Diaz 2012/10/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,131 reads

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

Query dBase .dbf Files From SQL 2012 64-bit.  Read more...
By James Ochsenfeld 2012/05/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 826 reads

Swiss Cheese!

Are you trying to determine the gaps in a numerical sequence?   Read more...
By John Esraelo 2012/04/26 | Source: SQLServerCentral.com | Category: sql script
Rating: |  Discuss |   Briefcase | 942 reads

Did you say denormalize, why?

How to display data from 1-to-many in a single record!  Read more...
By John Esraelo 2012/04/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,144 reads

Script to get database restore history

T-SQL to get restore history of SQL databases.  Read more...
By Suleman Mohammed 2012/03/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,351 reads

Split Function to break the Job History Message into a Table

Split Function for T-SQL Server to break the Job History Message into Table.  Read more...
By Ludwig Guevara 2012/03/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,004 reads

Select the last error in the job selected

The job will send an HTML email with the latest error at specific job.  Read more...
By Ludwig Guevara 2012/03/15 | Source: SQLServerCentral.com | Category: sql jobs
Rating: (not yet rated) |  Discuss |   Briefcase | 837 reads

TSQL fast unix timestamp conversion

How to convert Unix timestamp into datetime taking into account also summer or winter time  Read more...
By Federico Iori 2011/12/02 | Source: SQLServerCentral.com | Category: timestamp
Rating: |  Discuss |   Briefcase | 447 reads

Compare 2 datasets and output delta in one TSQL statement

There are many ways 2 compare datasets to find differences, this is one of them.  Read more...
By Theo Ekelmans 2011/11/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,087 reads

who can do what?

list each user has the right to do  Read more...
Rating: |  Discuss |   Briefcase | 2,184 reads

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

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  Read more...
By Parag Bhuyar 2011/11/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,265 reads

Convert string Hex to Numeric with inline TSQL

A fast way to convert a string containing Hex values to numeric  Read more...
Rating: |  Discuss |   Briefcase | 1,253 reads

Grouping Sets

This script is to check for Queries returning same result set.  Read more...
By Vaidya VS 2011/10/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 831 reads

Copy One Schema to Another Schema

This script copies one object in another multiple schema.  Read more...
By Vinay Kumar 2011/08/31 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,145 reads

Change Time Zone on Server without Logging on to Box

Sometimes logging onto a box for a simple change like this is not possible for the business. This allows you to change this directly from T-SQL without having to log on or RDP into the box.  Read more...
By Shirley Bouzon 2011/08/17 | Source: SQLServerCentral.com | Category: time zone
Rating: |  Discuss |   Briefcase | 424 reads

Verify a database backup using T-SQL

A script to verify a database backup using T-SQL code  Read more...
By Nakul Vachhrajani 2011/07/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,656 reads

Remove tab,line feed and carriage return frome text field

Remove tab,line feed and carriage return frome text field  Read more...
By Harsha Majety 2011/04/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,698 reads

Extend CHARINDEX with occurance matching

Retrieve the charindex of matching string for the desired occurrence  Read more...
By Partha Pal 2011/04/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,364 reads

Append Value to Delimited List

Takes a delimited list and appends a value to the end.  Read more...
By Chad Casady 2011/03/04 | Source: SQLServerCentral.com | Category: udf
Rating: |  Discuss |   Briefcase | 6,073 reads
<< Newer    Items 41 to 60 of 886    Older >>