11 Jun 2009

How can take backup from table...

How can take backup from table to another table in the same database?
We can use SELECT INTO to take backup.

We can select:
1.One column or more
select column1
into NewTable
from OldTable



2.All columns

select *
into NewTable
from OldTable


Also we can use where
select *
into NewTable
from OldTable
where column1='Haia'

0 comments: