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

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

Sometime we need to update one table based on the values of another table. Which table need to be updated is called target table or...

MS SQL Server provides has a number of built-in options to format a date and time in different ways.  Here are the list of built-in...

If you have a column in a SQL Server table that does not allow NULL values and you want to insert row(s) with NULL values,...