Try {} catch {} instance in SQL

 

 

Alter procedure [dbo]. [P_DangerSource_File_Add]
@ SourceName varchar (50), -- name
@ TypeID int, -- type
@ DangerLevel varchar (30), -- hazard level
@ IsControl bit, -- whether to monitor
@ SourceLocation varchar (200) -- hazard source location
@ SourceNum int, -- number of hazard sources
@ Descrip varchar (200) -- hazard description
@ Accident varchar (150), -- an Accident may occur
@ Summarize varchar (200), -- Overview
@ Supervisor varchar (30), -- owner
@ Telephone varchar (50), -- contact number
@ UserID varchar (50), -- registrant ID
@ InDate datetime, -- Registration Date
@ IsChanged bit, -- whether to change
@ DeptID varchar (20) -- department ID
AS

Begin Try

Insert into T_DangerSource_File (
[SourceName],
[TypeID],
[DangerLevel],
[IsControl],
[SourceLocation],
[SourceNum],
[Descrip],
[Accident],
[Summarize],
[Supervisor],
[Telephone],
[UserID],
[InDate],
[IsChanged],
[DeptID]
) VALUES (
@ SourceName,
@ TypeID,
@ DangerLevel,
@ IsControl,
@ SourceLocation,
@ SourceNum,
@ Descrip,
@ Accident,
@ Summarize,
@ Supervisor,
@ Telephone,
@ UserID,
@ InDate,
@ IsChanged,
@ DeptID
)

Return SCOPE_IDENTITY () -- returns the ID last inserted to the data table

End Try

Begin Catch
Return-1
End Catch