Say I have a sql query like this:
Declare @table1 TABLE(id INT, field1 VARCHAR(100))
INSERT INTO @table1
SELECT 1,'Apple Juice'
UNION ALL SELECT 2,'Orange Juice'
UNION ALL SELECT 3,'Coffee and tea'
UNION ALL SELECT 4,'randam text...'
UNION ALL SELECT 5,'I eat an apple everyday'
Select * from @table1
where field1 not like '%apple%' and field1 not like '%orange%'
Now I want to put the hard code values "apple" and "orange" into a table so that I can update it without modifying SP or Query string in asp file.
How can I do it?
Thanks!
How to move not like string into table??
Posted - 12/04/2012 : 22:14:42
