how to create stored procedure with two table parameter list

DommyBoii

New Member
UserInfo---->ID(identity),FirstName,LastName,AddressUserContact--->Id(identity),userinfoid(first table id),contactype,contactnoI wrote two table parameters in single stored procedure.but when i am trying to execute first table it displaying an error.Procedure or function 'InsertUser' expects parameter '@ContactType', which was not supplied.
 
Back
Top