freetechtrainer

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

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