将多个值存储在变量中 [英] Store multiple values in variable

问题描述

大家好，



我想在SQL中存储特定列的所有行值



我尝试过：

Hi All,

I want to store all rows values of particular column in SQL

What I have tried:

declare @a int
declare @b int

set @a= select Stock from ABC
set @b= select month from ABC

And use loop for further calculation 

while @i< 12
if @a > b 
return @a
@i=@i+1

推荐答案

如果你想返回股票和 [月] 有一些标准的列，试试这个：

If you want to return Stock and [month] columns with some criteria, try this:

SELECT Stock, [month]
FROM ABC
WHERE Stock > [month]

DECLARE @a INT,@b INT,@c INT=0;
DECLARE @ABC TABLE(id INT identity(1,1),stock int,month INT);
BEGIN
   INSERT INTO @ABC(Stock,month) SELECT Stock,Month FROM ABC;

    WHILE @c<=(SELECT COUNT(1) FROM @ABC)

     BEGIN
       SELECT @a=Stock,@b=month FROM @ABC WHERE ID=@c;
        if @a>@b 

         SELECT @a;
          ELSE 
         SELECT @b;

      SET @c=@c+1;
     END;
END;

这篇关于将多个值存储在变量中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！