第一种
ALTER PROCEDURE B_EMPLOYEE_PWD_VAR @ID bigint,
@UserPwd nvarchar(12)
AS
/*验证用户密码*/
SELECT UserPwd
FROM B_Employee
WHERE (ID = @ID) AND (UserPwd = @UserPwd)第二种
ALTER PROCEDURE B_EMPLOYEE_PWD_VAR @ID bigint,
@UserPwd nvarchar(12)
ASDeclare @a nvarchar(12) /*验证用户密码*/
SELECT @a=UserPwd
FROM B_Employee
WHERE (ID = @ID) AND (UserPwd = @UserPwd)
RETURN @a这俩中方法得到的结果是不是一样啊?在C#中都能调用到这俩中方法的结果?
ALTER PROCEDURE B_EMPLOYEE_PWD_VAR @ID bigint,
@UserPwd nvarchar(12)
AS
/*验证用户密码*/
SELECT UserPwd
FROM B_Employee
WHERE (ID = @ID) AND (UserPwd = @UserPwd)第二种
ALTER PROCEDURE B_EMPLOYEE_PWD_VAR @ID bigint,
@UserPwd nvarchar(12)
ASDeclare @a nvarchar(12) /*验证用户密码*/
SELECT @a=UserPwd
FROM B_Employee
WHERE (ID = @ID) AND (UserPwd = @UserPwd)
RETURN @a这俩中方法得到的结果是不是一样啊?在C#中都能调用到这俩中方法的结果?
ALTER PROCEDURE B_EMPLOYEE_PWD_VAR@ID bigint,
@UserPwd nvarchar(12),
@a int outputAS
/*验证用户密码*/
SELECT @a=UserPwd
FROM B_Employee
WHERE (ID = @ID) AND (UserPwd = @UserPwd)
ALTER PROCEDURE B_EMPLOYEE_PWD_VAR @ID bigint,
@UserPwd nvarchar(12),
@a nvarchar(12) output
AS /*验证用户密码*/
SELECT @a=UserPwd
FROM B_Employee
WHERE (ID = @ID) AND (UserPwd = @UserPwd)
RETURN @a
第一种方法返回的是一个结果集,尤其是查物品列表的使用比较多
第二种就如同函数一样
根据你的定义,Declare @a nvarchar(12)
只是返回一个字串而已
其他的時候可以用Select
一个是返回状态,int型
但@a=UserPwd啊那你的意思是不是当返回的结果集中只有一条记录时,俩种方法一样返回的结果集中有多条记录时,它们就不一样了