如何将设置结果值传递给另一个值..？ [英] How to pass set result value to another value..?

问题描述

DECLARE @CompID NVARCHAR（MAX），

@sql NVARCHAR（MAX），

@Result NVARCHAR（MAX）;

SET @CompID = 245;

SET @sql ='SELECT COUNT（Cw.LocWeight）FROM LocationWeight Cw，其中Cw.CompanyID = 245';

SET @Result = @sql ;



我尝试了什么：



如何传递@sql结果值为@Result

DECLARE @CompID NVARCHAR(MAX),
@sql NVARCHAR(MAX),
@Result NVARCHAR(MAX);
SET @CompID = 245;
SET @sql = 'SELECT COUNT(Cw.LocWeight) FROM LocationWeight Cw where Cw.CompanyID = 245';
SET @Result = @sql;

What I have tried:

how to pass @sql result value to @Result

推荐答案

试试这样

try like this

DECLARE @CompID NVARCHAR(MAX),
@sql NVARCHAR(MAX),
@Result int;
SET @CompID = 245;
SET @sql = 'SELECT @Result= COUNT(Cw.LocWeight) FROM LocationWeight Cw where Cw.CompanyID = 245'; 

 EXEC SP_EXECUTESQL 
        @Query  = @sql
      , @Params = N'@Result int OUTPUT'
      , @Result  = @Result OUTPUT 

	  select @Result

来自这个 [ ^ ]

这样做：它与说法相同：

That does: it's same as saying:

DECLARE @sql NVARCHAR(MAX), @Result NVARCHAR(MAX);
SET @sql = 'A string of text';
SET @Result = @sql;
SELECT @Sql AS Sql, @Result AS Result

哪个选择：

Which selects:

Sql                Result
A string of text   A string of text

这篇关于如何将设置结果值传递给另一个值..？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！