hi,
i would like to know is there any error handling mechanism available in sqlserver.
for eg. if i want to enter a record only if the employee_id is not available in the table.
in oracle we have various exceptions, in .net we have try catch i would like to know such type of exception handler in ms sql.
thanks in anticipation
Raj

yes, there is BEGIN TRAN and COMMIT TRAN / ROLLBACK TRAN together with @@ERROR variable.