SQL+ASP骨灰级高手请进!
tddw 2004-04-05 03:02:40 这是我写的一个存储过程
--------------------------------------------------------
CREATE PROCEDURE [dbo].[sp1_nicknameSave]
@uid char(20),
@nickname varchar(30)
AS
DECLARE @retcode int
SET LOCK_TIMEOUT 1000
begin TRAN
IF EXISTS(select * from mbr_nickname (updlock) WHERE nickname = @nickname)
BEGIN
SET @retcode = 1000
GOTO L_Return
END
EXEC @retcode = sp3_mbr_nickname_i
@uid = @uid,
@nickname =@nickname
L_Return:
IF @@TRANCOUNT > 0
BEGIN
IF @retcode = 0
COMMIT
ELSE
ROLLBACK
END
SELECT @retcode retcode
GO
--------------------------------------------------------
请问我怎么在ASP中得到retcode的返回值?
谢谢!
另外请哪一位高手推荐一篇SQL存储过程的文章看一下
一定要详细
谢谢
另:请不要叫我定义output型的变量
此帖一共200分
结帖后开新帖再给100