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 |
|
OMB
Yak Posting Veteran
88 Posts |
 Posted - 2001-06-20 : 06:38:13
|
| here is the trigger i am having prob withcreate trigger update_barcode_table on stmbiogr for insert, update asinsert into stmstdets (student_id, u_version)select student_id, u_version from inserted where not exists (select * from stmstdets where stmstdets.student_id = inserted.student_id)goI basically want to copy any new inserted records in stmbiogr to stmstdets.it is currently deleting the inserted record from stmbiogr and not putting the record in stmstdets.thaxsEdited by - omb on 06/20/2001 09:18:38 |
|
|
|
|
|
trigger not working