方法一:
DECLARE @SQL NVARCHAR(256)
DECLARE @ReturnID INT
SET @SQL = 'SELECT [InfoID] FROM TM_TeachInfo WHERE [CourseID]=1 and [infosort]=1'
EXEC(@SQL)
SELECT @ReturnID = @@Rowcount
SELECT @ReturnID
方法二:
ALTER PROCEDURE UP_TM_TeachInfo_Exists_ByStr
@strWhere varchar(1000)
AS
DECLARE @ReturnID int
DECLARE @Sql nvarchar(400)
set @sql = 'SELECT @ReturnID = count(1) FROM TM_TeachInfo WHERE 1=1 and '+@strWhere
exec sp_executesql @sql,N'@ReturnID int out',@ReturnID out
IF @ReturnID = 0
RETURN 0
ELSE
set @sql = 'SELECT @ReturnID = [InfoID] FROM TM_TeachInfo WHERE 1=1 and '+@strWhere
exec sp_executesql @sql,N'@ReturnID int out',@ReturnID out
RETURN @ReturnID