Back up a SQL Table

by ssi 30. April 2013 18:57

I use this SQL script to make a copy of a SQL table before I do  any  drastic update, deletionsor inserts.

SELECT *
INTO JobExpenses2_0
FROM dbo.JobExpenses2

SELECT *
INTO  tbl_ssi_Loans
FROM RegSolDocs2.dbo.tbl_ssi_Loans

SELECT *
INTO  tbl_ssi_Paragraph
FROM RegSolDocs2.dbo.tbl_ssi_Paragraph

Tags:

SQL

Calendar

<<  May 2024  >>
MoTuWeThFrSaSu
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789

View posts in large calendar

RecentComments

None

Development Team @ Shelbysys

We develop custom database applications for our clients. Our development tool of choice is MS Visual Studio. 

Quotations

"Procrastination is, hands down, our favorite form of self-sabotage"
Alyce P. Cornyn-Selby