Programmatically backup table

[Hackster]

Primarily I use Oracle, but for this particular project, I'm using SQL Server. When I want to copy an Oracle table through code, I say

create table tablename_bak 
as select * from tablename;

But, SQL Server gives me a syntax error. How do you do this in SQL Server language?

 

[hmckillop]

SELECT * INTO MyNewTable FROM MyOldTable

"I'm living so far beyond my income that we may almost be said to be living apart

 

[Hackster]

Thank you sir. That did the trick!

 

[hmckillop]

no problem

"I'm living so far beyond my income that we may almost be said to be living apart

 

[GUJUm0deL]

Can I use SELECT * INTO MyNewTable FROM MyOldTable to backup data from one table into the backup table up to a certain point in time? And, how can I delete the records from the actual table (since I have the data backed up in the backup table I don't need it in the actual table, right?)

Thanks.


____________________________________
Just Imagine.

http://www.imajinarts.com

 

[steven290]

couldn't you do this

"SELECT * INTO MyNewTable FROM MyOldTable; Delete * from MyOldTable

 

[GUJUm0deL]

I guess I can do that.

Do you see any downside to something like this? I described my situation here thread183-1032378

And would this be legal:

SELECT * INTO answers_backup
FROM answers
WHERE createdate <= '1/31/2004 23:59:59'

DELETE *
FROM answers
WHERE createdate <= '1/31/2004 23:59:59'

____________________________________
Just Imagine.

http://www.imajinarts.com