T-SQL

Add Primary key

This Store procedure is used to add primary key to all tables in a database, if table does not contain it.

Generate Insert Statements

This script Generates the insert statements for a particular table.

Print The Calender

It shows the Calender.

Shrink databases

This procedure is used to shrink the databases. Many times we use shrink option to shrink the databases for backup. and we do it N number of times, when we take the back of databses or make free space of drive.instructions:- Follwo the step.1. run script.2. And execute the statement, exec shrink_databasesI m new, if […]