SQL Server loop programming

Question

For Sql Server 2014, what syntax do I need, if this is even possible? (in pseudo-code)

DECLARE @searchstring nvarchar(20)
LOOP @searchstringstring = (SELECT keyword FROM table1)
SELECT column FROM table2 where column LIKE '%@searchstring%'
END LOOP

I want it to return all columns in a single table.

What are you trying to achieve here? Maybe it can be done using a set-based solution. — Felix Pamittan
– Felix Pamittan, Commented Apr 26, 2016 at 4:24
you can loop through while clause or cursor in sql server. but it is not a recommended approach — bmsqldev
– bmsqldev, Commented Apr 26, 2016 at 4:48
its not clear what you are trying to achieve,some example will help — TheGameiswar
– TheGameiswar, Commented Apr 26, 2016 at 4:57

Zohar Peled · Accepted Answer · 2016-04-26 05:06:39Z

1

Unless I'm missing something, you want to select all the values in table2.Column that contains the text in table2.Keyword. This can be done easily with a simple inner join:

SELECT t2.column
FROM table2 t2
INNER JOIN table1 t1 ON(t2.column LIKE '%'+ t1.keyword +'%'

Sql works best with set based operations. looping is rarely the desired approach.

answered Apr 26, 2016 at 5:06

Zohar Peled

82.9k10 gold badges79 silver badges134 bronze badges

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

Collectives™ on Stack Overflow

SQL Server loop programming

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related