我有动态查询我想从中获取两个输出参数我使用以下代码,但输出参数返回null
- declare @query nvarchar(max);
- declare @result int;
- declare @type int
- declare @mainVarcharLength int;
- set @query = 'select count(*),Type_Code from Customers WHERE Customers.Cust_Name = ''CUSTOMER 99'' '
- set @query = @query + ' and Cus_Is_Active = 1 Group BY Type_Code';
- select @query
- EXEC sp_executesql @query,N'@result int OUTPUT,@type int OUTPUT',@result,@type
- select @result
- select @type
