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 |
|
sharmila
Starting Member
4 Posts |
 Posted - 2006-07-19 : 07:49:56
|
| hiactually i have a temporay table wich has four columns say col_1,col_2,col_3,col_4.so firstly i wud bulk insert from a text file wich mite contain thousands of rows.then from this temp table col_1 and col_2 shd go to master_a.wich has an identiy column as primary key.say id,col_1, col_2.i will have another table detail_b where in there is a foreign key to the table master_a for id.so it will have f_id, col_3,col_4.so i am riting a trigger on master_a. so whenver row is inserted in master_a. coresponding id and col 3 col4 shd be inserted into detail_b.For this in oracle we have row level trigger. where in for each insertion in master a .. correspoding trigger will fire but in sql 2000.. but i wud like to implemtn row level trigger..can u hlep me out.. |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-07-19 : 16:16:03
|
| SQL Server doesn't support row-level triggers. You can use set-based logic using inserted inside an insert trigger.Ken |
 |
|
|
|
|
|
sql server 2005 + row level trigger