ALTER PROCEDURE procrowcount
(
@utypeid varchar(50),
@utype varchar(25)
)
AS
BEGIN
INSERT INTO UsersType(UTypeId,UType) VALUES(@utypeid,@utype)
IF(@@ROWCOUNT>0)
BEGIN
INSERT INTO UsersType(UTypeId,UType) VALUES('7','Sujatha')
END
ELSE IF (@@ROWCOUNT=0)
BEGIN
ROLLBACK
PRINT 'RECORD NOT INSERTED'
END
END
|
No responses found. Be the first to respond and make money from revenue sharing program.
|