|
|
|
Author |
Message |
Johnnymag
|
Posted: Tue Jul 27 17:27:14 CDT 2004 |
Top |
SQL Server Developer >> Insert Help
I have a table called Mixer and with (Mixno int, Mixname varchar(50), Mixop int)
I have a sp that updates this table daily. I would like to export the old values in Mixno, Mixname, and Mixop into a new table called Mixold. Before any updates are applied.
Is it something like this
Insert into Mixold (Mixno,Mixname,Mixop) values (OLDmixno, OLDMixname, OLDMixop)
SQL Server238
|
|
|
|
|
Tom
|
Posted: Tue Jul 27 17:27:14 CDT 2004 |
Top |
SQL Server Developer >> Insert Help
Try:
Insert into Mixold (Mixno,Mixname,Mixop)
select
Mixno,Mixname,Mixop
from
Mixer
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
I have a table called Mixer and with (Mixno int, Mixname varchar(50), Mixop
int)
I have a sp that updates this table daily. I would like to export the old
values in Mixno, Mixname, and Mixop into a new table called Mixold. Before
any updates are applied.
Is it something like this
Insert into Mixold (Mixno,Mixname,Mixop) values (OLDmixno, OLDMixname,
OLDMixop)
|
|
|
|
|
|
|