Category: SQL

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

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

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

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

Sometimes you need to set a restriction in a columns of a table which will not allow NULL values in MS SQL Server. To do...

Sometime you may need to delete one or more unused or obsolete columns from your existing table. To do this, you need use the ALTER TABLE...