hi Frnds
i m giving the ex..suggest me how to do error handling in this example
Create Procedure Record
(
@id int,
@name Varchar(15),
@ Salary Decimal(10,2),
@StmtType Nvarchar(30)=""
)
As
Begin
if@stmttype='Insert'
Insert into employee(id,name,salary)values(@id,@name,@salary)
End
Begin
if@stmttype='Update'
update set employee name=@name,salary=@salary where id=@id
End....
Vipan SharmaPosted Mar 11, 2016, 2:29 AM
anjali khanPosted Mar 11, 2016, 2:42 AM
Vipan SharmaPosted Mar 11, 2016, 2:39 AM
anjali khanPosted Mar 11, 2016, 2:35 AM
Amit Kumar SinghPosted Mar 11, 2016, 2:27 AM
(
@Id INT,
@NAME VARCHAR(50),
@GENDER VARCHAR(50),
@SALARY VARCHAR(50),
@COUNTRY VARCHAR(50),
@Opt varchar(5)
)
AS
BEGIN
BEGIN TRY
IF(@Opt='S')
BEGIN
SELECT Name FROM Employee WHERE Name like @NAME + '%'
END
IF(@Opt='S2')
BEGIN
--SELECT Id,Name FROM Employee WHERE Id like CAST(@Id AS VARCHAR) + '%' OR NAME like @NAME +'%'
SELECT Id,Name FROM Employee WHERE Id=@Id or Name=@Name
END
IF(@Opt='S1')
BEGIN
SELECT * FROM Employee
END
END TRY
BEGIN CATCH
DECLARE @ErrorMSG NVARCHAR(4000), @ErrorSeverity VARCHAR(10), @ErrorState VARCHAR(10), @ErrorProcedure NVARCHAR(200)
SET @ErrorMSG = ERROR_MESSAGE()
SET @ErrorSeverity = ERROR_SEVERITY()
SET @ErrorState = ERROR_STATE()
SET @ErrorProcedure = ERROR_PROCEDURE()
RAISERROR(@ErrorMSG, @ErrorSeverity, @ErrorState, @ErrorProcedure)
END CATCH
END