hai friends
pls correct my sp,given code below
CREATE PROCEDURE wyapaar_kviva.updatetable
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
@Name varchar(15),@Dob varchar(5), @Specicase varchar(15), @nativitydetails varchar(15), @address varchar(20), @Vid int, @userid varchar(15)
BEGIN TRANSACTION
AS
UPDATE VivaReg
SET Name = @Name,Dob=@Dob
WHERE Vid=@Vid and userid=@userid
IF @@error <> 0
BEGIN
ROLLBACK TRANSACTION
RAISERROR("Unable to update VivaReg", 16, 1)
RETURN
END
UPDATE ViReg1
SET address = @address,nativitydetails=@nativitydetails
WHERE Vid=@Vid and userid=@userid
IF @@error <> 0
BEGIN
ROLLBACK TRANSACTION
RAISERROR("Unable to update ViReg1", 16, 1)
RETURN
END
COMMIT TRANSACTION
|
| Author: Kumar Velu 19 Jul 2008 | Member Level: Diamond | Rating:  Points: 6 |
CREATE PROCEDURE wyapaar_kviva.updatetable
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT,
@Name varchar(15),@Dob varchar(5), @Specicase varchar(15), @nativitydetails varchar(15), @address varchar(20), @Vid int, @userid varchar(15)
)
BEGIN TRANSACTION
AS
UPDATE VivaReg
SET Name = @Name,Dob=@Dob
WHERE Vid=@Vid and userid=@userid
IF (@@error <> 0)
BEGIN
Print 'Unexpected error occured'
ROLLBACK TRANSACTION
RETURN 1
END
UPDATE ViReg1
SET address = @address,nativitydetails=@nativitydetails
WHERE Vid=@Vid and userid=@userid
IF (@@error <> 0)
BEGIN
Print 'Unexpected error occured'
ROLLBACK TRANSACTION
RETURN 1
END
COMMIT TRANSACTION
Return 0
|
| Author: Bindu Bujji 19 Jul 2008 | Member Level: Gold | Rating: Points: 1 |
Can u please explain what is the wrong with this stored procedure??
thanks
|