Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how take backup of table values??

Author  Topic 

samsun125
Yak Posting Veteran

63 Posts

Posted - 2008-11-05 : 04:58:41
Hi all,

i want to modify one table values before that i want to take backup of that table values

how to do


Thanks & Regards

sams

NeilG
Aged Yak Warrior

530 Posts

Posted - 2008-11-05 : 05:10:53
you could just create an extra table as a backup i.e

Select * into backupTableName20081105
from
TableName

depends really on how big the table is and whether you need to add criteria in a where clause to limit the results
Go to Top of Page

samsun125
Yak Posting Veteran

63 Posts

Posted - 2008-11-05 : 05:43:31
Hi NeilG'

Thank you very much

Regards
sams
Go to Top of Page
   

- Advertisement -