Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
problem with query on a Datetime field
Hi all, I have a problem with a query on a Datetime field. pls go thorugh the details. Table name - HOLIDAYLIST Fields in table. 1. HolidayName (varchar) 2. HolidayDate (Datetime) Data in table (only one row is present) 'My Holiday', 04/01/2001:00:00:00:00 (take it as dd-mm-yyyy) Query ---...- bobyjose
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
How to make all stmnts. in a TRIGGER execute regardless of an error
Collin..Thats exactly whatz going worng! When i insert data that violates Ref. Integrity into another table from the trigger, it cancels the execution of the remaining statements. <br>You mean to say that i've to disable all foreign keys in the table to which i'm inserting data and...- bobyjose
- Post #5
- Forum: Microsoft SQL Server: Programming
-
How to make all stmnts. in a TRIGGER execute regardless of an error
Thanx Collin, for the reply. But, unfortunately, the trigger executes only upto the insert statement where the error occurs, whether or not you put the statements in a transaction!!<br>Any other suggestion?- bobyjose
- Post #3
- Forum: Microsoft SQL Server: Programming
-
How to make all stmnts. in a TRIGGER execute regardless of an error
Hello ,<br>I'm using Microsoft sql 7.0.<br>I have a trigger on a table which contains code to insert data into a second table. If this insert fails (for eg. due to a referential integrity violation), it raises an error and the trigger terminates without executing the remaining statements (where...- bobyjose
- Thread
- Replies: 8
- Forum: Microsoft SQL Server: Programming
