Hi, i tried to work on stored produre.But it return me error. I had create my own stored procedure as below :
CREATE PROCEDURE test
@WIPID int,
@serialnumber varchar(100),
@CustomerID int,
@Active bit,
@BirthStatus varchar(10),
@BirthDate datetime
AS
SELECT WIP_ID, SerialNumber, Customer_ID, Active, BirthStatus, BirthDate
FROM BoardInfo
WHERE WIP_ID = @WIPID
BEGIN
IF @WIPID != 0
BEGIN
IF @WIPID in (SELECT WIP_ID FROM BoardInfo)
BEGIN
UPDATE BoardInfo SET WIP_ID =@WIPID, SerialNumber =@serialnumber,
Customer_ID =@CustomerID , Active =1, BirthStatus =1 , BirthDate = @BirthDate where WIP_ID =@WIPID
END
ELSE
BEGIN
...
Go to the complete details ...