从SQL Server 2012开始,您需要使用
WITH RESULT SETS来显式描述结果集:
EXEC('exec [MyDatabase].[dbo].[StoredProcedure] WITH RESULT SETS (( val SMALLINT));')
从SQL Server 2012开始,您需要使用
WITH RESULT SETS来显式描述结果集:
EXEC('exec [MyDatabase].[dbo].[StoredProcedure] WITH RESULT SETS (( val SMALLINT));')