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!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bobyjose
  • Content: Threads
  • Order by date
  1. bobyjose

    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 ---...
  2. bobyjose

    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...

Part and Inventory Search

Back
Top