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 |
|
cmschick
Starting Member
20 Posts |
 Posted - 2006-03-29 : 09:54:40
|
| I have an INSTEAD OF INSERT trigger that I cannot get to save. The syntax check comes out fine but I get the error message "Stored procedure definition must include name and text (for standard StoredProcedure)...."What is wrong with this trigger definition? Thank you.CREATE TRIGGER ustr_InsertPatientPhoneEmailON vwPatientPhoneEmail INSTEAD OF INSERTASBEGIN -- Make sure the inserted data updates the junction table. INSERT INTO PatientPhone (PatientID, PhoneID, EmpCreated, DateUpdated, EmpUpdated) SELECT inserted.PatientID, SCOPE_IDENTITY() AS PhoneID, inserted.EmpCreated, inserted.DateUpdated, inserted.EmpUpdated FROM inserted COMMIT TRANSACTIONENDThe Schickster |
|
|
|
|
|
Help with Trigger