How to Create a PRIMARY KEY in SQL Server
A primary key is a column or a group of columns that uniquely identifies each record in a table. You can create a primary key...
What is the Equivalent of DESCRIBE table in MS SQL Server
Working with a table sometimes we need to know the structure of the table i.e variable_name, variable_type, variable_size, constraint etc. In Oracle we use DESCRIBE...
Creating DESC Procedure To Describe Table in MS SQL Server
In Oracle it is easy to see the structure of a table by executing DESCRIPTION or DESC command. In SQL there is no such command....
How to Rename Column Name in MS SQL Server
Sometimes we need to rename a column name of a table in our MS SQL Server database. It is very much easy to change or...
How to Change Data Type of a Column in MS SQL Server
Sometimes you may need to change data type of a column in a table in MS SQL Server. To do this, you need to use...
Bulk INSERT in MS SQL Server
Sometimes you need to insert multiple rows into your desired table in MS SQL Server. A Bulk insert is a process or method provided by...