Skip to content
Advertisement

Error converting data type varchar to int error in stored procedure

My stored procedure is

And my table

This is working fine

This query works fine but when I am trying to insert it using stored procedure it throws an error.

I have an identity specification for customer_id on so no need to insert it

Now when I am trying to execute my stored procedure with the following statement

I get:

Error converting data type varchar to int

Advertisement

Answer

Please pass null value in procedure while you insert the data in table. Run the procedure below way while inserting data in table. you should me manage all the parameter of procedure. you are not passed value of Customer_ID, so that’s way error occur.

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement