Tips of Using MS SQL

Using SQLCMD to execute SQL scripts



First, create a folder on your computer and call it something such as scripts and then drop your scripts into the folder (Figure A).



Figure A.
Next, create a batch file that points to the script or scripts that you created (Figure B).



Your script or scripts can be as easy or as complex as you want. Create a set of scripts to help you in your daily life.

Using Tsql to do backup