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

list each user has the right to do  Read more...

Distinct Query   Read more...

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...

A fast way to convert a string containing Hex values to numeric  Read more...

This script is to check for Queries returning same result set.  Read more...

This script copies one object in another multiple schema.  Read more...

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...

A script to verify a database backup using T-SQL code  Read more...

Remove tab,line feed and carriage return frome text field  Read more...

Retrieve the charindex of matching string for the desired occurrence  Read more...

Takes a delimited list and appends a value to the end.  Read more...

We often have need of string splitting in applications. I had need of one in some T-SQL development I am currently doing for a friend.  Read more...

Get the rowcount in all tables  Read more...

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.  Read more...

IsDate function returns 1 for a numeric value  Read more...

This func returns the max value,min value and count of values from collection of values  Read more...

I have added 2 functions here, one for email validation and another to split the string by specified separator by user.  Read more...

SQL Script to generate columns for triggers  Read more...

This function evaluates the statement like '4+5*6-3' and returns the numeric value.It is just like Eval funcction in javascript.  Read more...