SELECT @usr_no=USR_NO,@jf=JF FROM HD_USR WHERE USR_NO=@another_usr_no
IF @usr_no is null
BEGIN
INSERT INTO HD_USR(USR_NO,MyTime)
VALUES(@usr_no,'0','dd','09',GETDATE())
END
ELSE
BEGIN
INSERT INTO MT_CMPP (USR_NO,NR)
VALUES(@usr_no,'您目前的积分为:'+@jf)
END
IF @usr_no is null
BEGIN
INSERT INTO HD_USR(USR_NO,MyTime)
VALUES(@usr_no,'0','dd','09',GETDATE())
END
ELSE
BEGIN
INSERT INTO MT_CMPP (USR_NO,NR)
VALUES(@usr_no,'您目前的积分为:'+@jf)
END
BEGIN
INSERT INTO HD_USR(USR_NO,MyTime)
VALUES(@usr_no,'0','dd','09',GETDATE())
END
ELSE
BEGIN
INSERT INTO MT_CMPP (USR_NO,NR)
VALUES(@usr_no,'您目前的积分为:'+(select jf from HD_USR WHERE USR_NO=@usr_no))
END
不过第一句好像有问题
IF @@rowcount=0
INSERT INTO HD_USR(USR_NO,MyTime)
VALUES(@usr_no,'0','dd','09',GETDATE())
ELSE
INSERT INTO MT_CMPP (USR_NO,NR)
VALUES(@usr_no,'您目前的积分为:'+@jf)