CREATE PROCEDURE IsHaveValue
(
@Field_Name nvarchar(50),
@FieldValue nvarchar(50),
@tempCount int Output
)
AS
DECLARE @SQL VARCHAR
SET @SQL='Select @tempCount=count(*) from web_user_info where '+@Field_Name+'='+@FieldValue
EXEC @SQL
GO我的存储过程这样写,检查可以通过,但确不能正常调用,请大家帮帮忙
(
@Field_Name nvarchar(50),
@FieldValue nvarchar(50),
@tempCount int Output
)
AS
DECLARE @SQL VARCHAR
SET @SQL='Select @tempCount=count(*) from web_user_info where '+@Field_Name+'='+@FieldValue
EXEC @SQL
GO我的存储过程这样写,检查可以通过,但确不能正常调用,请大家帮帮忙
(
@Field_Name nvarchar(50),
@FieldValue nvarchar(50),
)
AS
Select count(*) as Nums from web_user_info where @Field_Name = @FieldValue
Return不知道可不可以
你这样试试看,int i = cmd.ExecuteScalar();看看i是不是总纪录数。(cmd是SqlCommmand对象)
(
@Field_Name nvarchar(50),
@FieldValue nvarchar(50),
@tempCount int Output
)
AS
SET Select @tempCount=count(*) from web_user_info where Field_Name=@Field_Name and FieldValue=@FieldValue
GO