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'
11 Jun 2009
How can take backup from table...
Posted by
Hayfa
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment