Before you update or delete data from a table, it is always a good idea to make a backup just in case. Using the INTO clause in your sql statement, allows you to do this.
Month: July 2017
Extract code from your databases
Quick, you need to get all of the code for all of your stored procedures in your database! All you need to do is go to your source control system and get them right? What do you mean you do not have them, well here is how to extract them from the database so you can create a source control baseline.
Jim Salasek's SQL Server Blog 