How to add string in sql

Question

Hello my code is as follows:

DECLARE @cnt INT = 0;
WHILE @cnt < 256
BEGIN
SELECT
ITEM1 ,
ITEM2 ,
ITEM3
FROM Table_Name
SET @cnt = @cnt + 3
End

I want to do like below:

DECLARE @cnt INT = 0;
WHILE @cnt < 256
BEGIN
SELECT
ITEM@cnt+1 ,
ITEM@cnt+2 ,
ITEM@cnt+3
FROM Table_Name
SET @cnt = @cnt + 3
End

So that it will be executed in a single loop. Please help me regarding this.

Thank you in advance

what are you trying to accomplish here? Why loop this?

S3S
– S3S

2018-06-25 16:21:58 +00:00
Commented Jun 25, 2018 at 16:21 — S3S
– S3S, Commented Jun 25, 2018 at 16:21
what's the expected results supposed to look like

S3S
– S3S

2018-06-25 16:34:47 +00:00
Commented Jun 25, 2018 at 16:34 — S3S
– S3S, Commented Jun 25, 2018 at 16:34

Andrea · Accepted Answer · 2018-06-25 14:58:28Z

1

If you want to compose your query using variables, you must use dynamic TSQL to construct your select, then you can execute it with EXEC(...):

DECLARE @sql varchar(max)= ' SELECT '
DECLARE @cnt INT = 0;

WHILE @cnt < 256
    BEGIN
        set @cnt = @cnt + 1
        set @sql = @sql + ' ITEM' + cast(@cnt as varchar(max)) + ',' 
    End
set @sql = replace (@sql + ' from #table_name',', from',' from')

exec (@sql)

answered Jun 25, 2018 at 14:58

Andrea

12.5k17 gold badges71 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to add string in sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related