方法一：
1
DECLARE @SQL NVARCHAR(256)
2DECLARE @ReturnID INT
3
4SET @SQL = 'SELECT [InfoID] FROM TM_TeachInfo WHERE [CourseID]=1 and [infosort]=1'
5
6EXEC(@SQL)
7
8SELECT @ReturnID = @@Rowcount
DECLARE @SQL NVARCHAR(256)2
DECLARE @ReturnID INT3
4
SET @SQL = 'SELECT [InfoID] FROM TM_TeachInfo WHERE [CourseID]=1 and [infosort]=1'5
6
EXEC(@SQL)7
8
SELECT @ReturnID = @@Rowcount
