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