exec 执行结果问题
掌心 2009-07-02 03:27:58 存储过程:
@MemNo varchar(22),
@MemEmail varchar(50),
@TableName varchar(100)
AS
BEGIN
--SET NOCOUNT ON
DECLARE @n int,
@sql Nvarchar(2048) ;
SET @sql='select count(MemEmail) n from
YesbB2BUser.'+@TableName+'_info info,
YesbB2BUser.'+@TableName+' ent where
info.memid=ent.MemId and ent.MemNo='''+@MemNo+'''
and info.MemEmail='''+@MemEmail+''''
EXEC sp_executesql @sql,N'@a int output',@n output;
--return @n;
select 1
--SET NOCOUNT ON
END
.net 用ExecuteScalar方法接收返回对象
这样写返回0 如果注释掉select 1上面的部分,就返回1,这是为什么?