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

<<  July 2025  >>
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

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

"A woman's guess is much more accurate than a man's certainty."
Rudyard Kipling