不是很清楚你的意图，不过可以给一段代码参考：
/****** Object: Stored Procedure dbo.AddLogin Script Date: 2001-7-28 17:31:00 ******/
CREATE PROCEDURE AddLogin
@userid varchar(8),
@password varchar(16),
@cdkey varchar(20),
@question varchar(100)= ' ',
@answer varchar(100)= ' '
AS
IF @userid= ' ' or @password= ' ' or @cdkey= ' '
RETURN 0 /*任意参数输入不得为空*/
IF EXISTS(SELECT [ID] FROM LoginInfo
WHERE [cdKey]=@cdkey)
RETURN -1 /*光盘已经被注册*/
IF EXISTS(SELECT [ID] FROM LoginInfo
WHERE [UserID]=@userid)
RETURN -2 /*用户名已经被占用*/
IF EXISTS(SELECT [ID] FROM UserInfo
WHERE [cdKey]=@cdkey)
BEGIN
INSERT INTO LoginInfo(UserID,Password,cdKey,question,answer)
VALUES(@userid,@password,@cdkey,@question,@answer)
RETURN 1 /*软件已经售出，注册成功*/
END
ELSE
RETURN -3 /*软件没有售出，拒绝注册*/
GO
|
