CREATE PROCEDURE dbo.formaNo
(
@FieldName char(50),@str char(50))
AS
declare @sqlstmt nvarchar(4000)
/*
set @sqlstmt='select count(*) from Eval where '+@FieldName+'=''+@str+'''
*/
set @sqlstmt='select count(*) from Eval where '+@FieldName+'='''+@str+''''
EXEC sp_executesql @sqlstmt
return
GO
(
@FieldName char(50),@str char(50))
AS
declare @sqlstmt nvarchar(4000)
/*
set @sqlstmt='select count(*) from Eval where '+@FieldName+'=''+@str+'''
*/
set @sqlstmt='select count(*) from Eval where '+@FieldName+'='''+@str+''''
EXEC sp_executesql @sqlstmt
return
GO
小女子万分感激!