Category: Tech Tips & Tricks

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

Sometimes we wanted to compress or zip our desired file or folder in windows. We do not need to install any third party software for...

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