下次要放分啊,记住欧。CREATE PROCEDURE dbo.sp_CheckUserExisted
@myName char(20),
@IsExisted bit(1) OUTPUTAS
IF 0 = (SELECT COUNT(*) FROM User_BasicInformation WHERE User_Name = @myName)
SET @IsExisted = false
ELSE
SET @IsExisted = true
GO
@myName char(20),
@IsExisted bit(1) OUTPUTAS
IF 0 = (SELECT COUNT(*) FROM User_BasicInformation WHERE User_Name = @myName)
SET @IsExisted = false
ELSE
SET @IsExisted = true
GO
--bit 不能赋予 false,true 变量
--try
CREATE PROCEDURE dbo.sp_CheckUserExisted
@myName char(20),
@IsExisted bit OUTPUTAS
IF 0 = (SELECT COUNT(*) FROM User_BasicInformation WHERE User_Name = @myName)
SET @IsExisted = 1
ELSE
SET @IsExisted = 0