t-sql code examples

Below are the TSQL Code (script) examples (samples) in this blog:

Sample script to removes non numeric Characters from string
TSQL Script to Strip Non Numeric Characters from string

Sample Script to Create Proxy In Detail
Script to Create Proxy In Detail

Sript to enable SA login with a password – You can find the script at the end of the post in the below link.
script to enable SA login with a password

Script to understand the behaviour of max aggregate function on varchar vs int column
using max agregate function on varchar column vs int column sql server

Script to fix the error Incorrect syntax was encountered while parsing GO.
Incorrect syntax was encountered while parsing GO

Test Script to find the maximum number of columns limitation for primary key.
What are the maximum number of Columns per index key,foreign key,primary key in SQL Server

Test Script to find the maximum number of columns in a table.
maximum number of columns in a table in SQL Server

Test Script to find the maximum number of columns in Select Statement.
find the maximum number of columns in Select Statement

Script to find error cannot drop database because it is currently in use.
cannot drop database because it is currently in use

Script to change sql server affinity mask setting in sql server
sql server affinity mask setting

Script to Convert VARCHAR to INT
Convert VARCHAR to INT SQL Server

Script to convert string to date yyyymmdd
sql server convert string to date yyyymmdd

Script to convert string to date mm dd yyyy
sql server convert string to date mm dd yyyy

(Visited 131 times, 1 visits today)