Stored Proc sending error Response back to the caller

Question

Hi, below is my Stored proc.
If I receive @Pointer input value as Alphabets or NULL or ' ' then I need to send response as "error occured: invalid input data provided."
How can I modify my stored proc. Do I need to apply if else logic ...... Please advise

ALTER PROCEDURE [dbo].[usp_TestData_Select]
     (

           @Pointer int,
           @count int
     )
AS

             Select  [ID]
            ,[ModelID]
            ,[Model]
            ,[InsuranceID]
            ,[VehicleType]

            case when @Pointer is not null then (select count(*) from [dbo].[testData]) end TotalRec 
            from [dbo].[TestData]
            Where [ID] between ((@Pointer*@count) + 1) and (@Pointer+1)*@count   



GO

Answer 1

Hi @Rock Hitman ，

The data type of your parameter @Pointer is int, Alphabets or NULL or '' are not of type int, so an error will be returned. For the variable @Pointer, you can only enter parameters of type int.
Or you can set the data type of @Pointer to char(25).

Hope this can help you.

If you have any question, please feel free to let me know.
If the response is helpful, please click "Accept Answer" and upvote it.

Regards
Echo

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I need to send response as "error occured: invalid input data provided."

For this you can use the RAISERROR command

Answer 3

IF @pointer IS NULL
BEGIN
   RAISERROR('You cannot pass NULL for the @pointer parameter', 16, 1)
   RETURN
END