Scripts

SQL Script to list all the columns of a table with the Schema Information

If you are looking for a SQL Script which will display a list of all columns in a table and also the Schema Information, you can use the following Script.

Working with the DataTime datatype in SQL Server can be very frustrating at times Especially, when you use them in your where clause. For example If you want to list all records within a certain date range, you might end up retrieving incorrect rows.

Here is the SQL Script to find the duplicate rows in a table in SQL Server

Is there any performance difference between using CHARINDEX vs LIKE in Where Clause?

Method  1:   Using the Select INTO Statement

If you are using the SQLCMD utility and want to avoid or suppress the column header in the output of SQL Script.

How to retrieve records from table which has null values.

Here is the Script which will list records which has null values for CountryID column.