Posted on: 8/29/2012 8:19:44 AM | Views : 999

I want "Vendor_ID" display in the message box after insert. But i am getting Error as "Procedure or function usp_User_Info3 has too many arguments specified". How to solve this ? The problem in SP or in Code ? Please help me out ?
Table :
CREATE TABLE User_Info2
(    SNo int Identity (2000,1) , 
     Vendor_ID AS 'VEN' + CAST(SNo as varchar(16)) PERSISTED PRIMARY KEY,  
     UserName VARCHAR(16) NOT NULL,
     User_Password VARCHAR(12) NOT NULL,
     User_ConPassword VARCHAR(12) NOT NULL,  
     User_FirstName VARCHAR(25) NOT NULL,  
     User_LastName VARCHAR(25) SPARSE NULL,
     User_Title VARCHAR(35) NOT NULL,
     User_EMail VARCHAR(35) NOT NULL,
     User_PhoneN ...

Go to the complete details ...