SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Blogs QotD SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us
 

Scripts with tag T-SQL Rss

Refine your search with one of the following additional tags (with number of items):

SQL Server 2005 (5)     Development (1)     Referential Integrity (1)     Table (1)    
String Manipulation (4)     Encode (1)     scalar-valued function (1)     Table-valued function (1)    
Automation (3)     ETL (1)     Script Generator (1)     Tools (1)    
Maintenance (3)     Index Management (1)     Search (1)     TSQL (1)    
Miscellaneous (3)     Insert Update Stored Procedure Generation (1)     Security (1)     T-SQL Aids (1)    
Administration (2)     Maintenance and Management (1)     SQL 2005 (1)     UDF (1)    
Advanced Querying (2)     Management (1)     SQL Server 2000 (1)     URL (1)    
Datetime Manipulation (2)     Puzzle (1)     Stored Procedure Template (1)     User-defined function (1)    
games (2)    

Search for any content tagged T-SQL

Add a script

   Items 1 to 20 of 36    Next 20 >>
 

Proc to Rename a file

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.  Read more...
By Simon Facer 2008/06/17 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 18 reads

A Sudoku solution with set based T-SQL utilizing binary operators.

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.  Read more...
By Kevin Duan 2008/06/09 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 103 reads

Calculate Age

This a function by which you can calculate the age of something.  Read more...
By Maysarah 2008/05/23 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 62 reads

URLEncode

Here is a short UDF to URL encode a string. Requires a numbers table.  Read more...
By Robert Cary 2008/05/21 | Source: SQLServerCentral.com | Category: URL
Rating: |  Discuss |  Briefcase | 50 reads

Calculate Easter Date

A function to calculate the date for Easter Sunday for a given year  Read more...
By DASUN 2008/06/02 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 24 reads

Tic Tac Toe TSQL Style

This allows a player to play tic tac toe against an automated computer.  Read more...
By adam haines 2008/03/11 | Source: SQLServerCentral.com | Category: TSQL
Rating: |  Discuss |  Briefcase | 967 reads

Removing Duplicate Records

How to remove duplicate records from a table.  Read more...
By Semseddin Moldibi 2008/04/18 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 1,894 reads

Generating permutations - procedure

This procedure prepares a query for generating permutations of n-numbers set and executes it.  Read more...
By Rafal S. 2008/03/18 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 369 reads

Enable Disable All Triggers in a Database

Enable Disable All Triggers in a Database  Read more...
By vinaykumar 2008/03/20 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 583 reads

Print The Calender

It shows the Calender.  Read more...
By vinaykumar 2008/03/14 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 913 reads

Discover Unique Columns

Tool to automatically query combinations of columns in your table to determine candidate for unique key.  Read more...
By Jesse McLain 2008/04/16 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 429 reads

Identify Large Tables

Reports on physical size of tables in your database to identify largest.  Read more...
By Jesse McLain 2008/03/13 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 753 reads

Parse the dependency chain of an object

Parses up & down the dependency chain of an object  Read more...
By Jesse McLain 2008/02/26 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 791 reads

Generate INSERT for table with IDENTITY column

Generate a "INSERT INTO...SELECT FROM" script for a table with an identity column.  Read more...
By Jesse McLain 2008/03/07 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 775 reads

Don't forget the Title

When using the output for generated code don't forget the title  Read more...
By Absinthe 2008/02/18 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 625 reads

Modify columns' name in batches

Modify columns' name in batches.  Read more...
By hxd001_810 2008/02/14 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 511 reads

Change column type on constrained columns

Use this proc if you need to alter a column that is part of a primery key  Read more...
By Luiz Barros 2008/02/04 | Source: SQLServerCentral.com | Category: Referential Integrity
Rating: (not yet rated) |  Discuss |  Briefcase | 491 reads

String Tokenizer with Complex Search

Sample solution to replace string in expressions with multiple delimiters.  Read more...
By tsaftalov 2008/01/31 | Source: SQLServerCentral.com | Category: String Manipulation
Rating: |  Discuss |  Briefcase | 747 reads

Refresh All Views

Refresh All views in Current Database.  Read more...
By BeoWulf . 2008/01/28 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 578 reads

Split by Row & Field delimitters

Like my tdard split but this will take a string and split it by 2 delimiters  Read more...
By Reddy Software Solutions 2007/12/28 | Source: SQLServerCentral.com | Category: String Manipulation
Rating: |  Discuss |  Briefcase | 852 reads
   Items 1 to 20 of 36    Next 20 >>
 
Most popular

Insert Update Stored Procedure for a table

Generic Script for Insert Update Stored Procedures  Read more...
By Prasad Bhogadi 2007/12/06 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 7,681 reads

Tic Tac Toe TSQL Style

This allows a player to play tic tac toe against an automated computer.  Read more...
By adam haines 2008/03/11 | Source: SQLServerCentral.com | Category: TSQL
Rating: |  Discuss |  Briefcase | 967 reads

How to empty database

Sometimes you need to empty the content of database. Following script can do that for you.  Read more...
By Boka | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 1,525 reads
 
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use