Skip to content Skip to sidebar Skip to footer

Don't Understand Sql Procedure Error

I have a master table 'Repairs' and a detail table 'RepairDetails' I am trying to write a procedure to update both tables when I send the appropriate parameters from my applicatio

Solution 1:

You cannot assign NULL to a table variable. Hence you can't check whether a table variable is NULL.

Second: no. You should call as follows:

EXEC UpdateRepairDetails @RepairID, @NewDetails;

Post a Comment for "Don't Understand Sql Procedure Error"