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

Add comment

biuquote
  • Comment
  • Preview
Loading

Calendar

<<  May 2026  >>
MoTuWeThFrSaSu
27282930123
45678910
11121314151617
18192021222324
25262728293031
1234567

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

""All glory is fleeting.""
General George S. Patton, Jr