How to execute sql string using SQL Server 2000

Question

I have a sql string that i would like to execute it in SQL Server 2000

Example:

DECLARE @CodeNameString VARCHAR(1000)
SET @CodeNameString = '%123% OR name LIKE %456% OR name LIKE %789%'
SELECT * FROM atable WHERE name LIKE @CodeNameString

Of course the above would be a lot easier in SQL 2008 but unfortunately i don't have that option...:

SET @CodeNameString = '"123" OR "456" OR "789"'
SELECT * FROM atable WHERE CONTAINS(name, @CodeNameString)

Is that possible?

StuartLC · Accepted Answer · 2014-07-24 16:12:28Z

1

I believe Sql 2000 also had dynamic Sql capabilities, in which case you can execute the whole query dynamically :

EXEC(N'SELECT * FROM atable WHERE name LIKE ''%123%'' 
       OR name LIKE ''%456%'' OR name LIKE ''%789%''')

answered Jul 24, 2014 at 16:12

StuartLC

108k18 gold badges225 silver badges294 bronze badges

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

1 Comment

StuartLC Over a year ago

N indicates that the string following is a Unicode literal e.g. NVARCHAR

Collectives™ on Stack Overflow

How to execute sql string using SQL Server 2000

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related