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....
Adding Two Numbers in Python
Python is very easy computer programming language. Today you will learn how to add two numbers in Python. You will also learn hear how to...
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...