CREATE PROCEDURE [dbo].[spc_ProcName]
(
@Ids varchar(max) = ''
)
WITH EXECUTE AS 'dbo'
AS
BEGIN TRY
SET NOCOUNT ON;
SELECT *
FROM [dbo].[Table] R
WHERE R.ID IN (SELECT items FROM dbo.tblfn_SplitIds(@Ids))
END TRY
BEGIN CATCH
EXEC [dbo].[spc_RaiseError];
END CATCH
CREATE PROCEDURE [dbo].[spc_RaiseError]
AS
BEGIN
SET NOCOUNT ON
DECLARE @ErrorMessage NVARCHAR(4000),
@ErrorSeverity
INT,
@ErrorState
INT,
@ErrorNumber
INT,
@ErrorLine
INT,
@ErrorProcedure
NVARCHAR(200)
SELECT
@ErrorMessage
=ERROR_MESSAGE(),
@ErrorSeverity
= ERROR_SEVERITY(),
@ErrorState
=ERROR_STATE(),
@ErrorNumber
= ERROR_NUMBER(),
@ErrorProcedure =ERROR_PROCEDURE(),
@ErrorLine
=ERROR_LINE();
IF @ErrorSeverity < 11
SET @ErrorSeverity = 11
--Raise the ERROR AND send back to the Web
Service
RAISERROR( N'Error IN Line Number: %d of SP: %s. Error Number: %d. ErrorMsg: %s', @ErrorSeverity,@ErrorState, @ErrorLine, @ErrorProcedure, @ErrorNumber, @ErrorMessage) WITH NOWAIT;
END
