Monday, 9 September 2013

What's wrong with this SQL Statement

What's wrong with this SQL Statement

In reference to my question I am trying this select statement and getting
error
Select * From
(SELECT * FROM FruitCrate WHERE FruitName IN (' +@FruitNames+ '))
WHERE FruitCrate.Eatable= 1
Error
Incorrect syntax near the keyword 'WHERE'.

No comments:

Post a Comment