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.
| Author |
Topic |
|
CRP
Starting Member
10 Posts |
 Posted - 2008-03-07 : 07:55:16
|
| i have two tables T1 and T2. Both has the same schema. I am inserting a few records manually in T1 which has columns empname and empid.I need to create a stored procedure which should delete a particular record in T1 based on the parameter value in T1. Before the record is deleted, it should get copied into table T2 which has the same schema. How to achieve this? Pls give me the full stored procedure coding.It is quite urgent.Thanx in advanceRegardsC.R.P RAJAN |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-03-07 : 07:57:50
|
| Insert into t2(columns)select columns from t1 where ....delete from t1 where .....MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Stored Procedure