Hi I just installed sql server 2005 for the first time today. Anyways I have a bunch of stored procs from an application i developed on the SQL 2000 server. Anyways I am having a problem with one of my stored procedures.
CREATE PROCEDURE ProvinceRetrieveAdHoc
(@.whereClause VARCHAR(256))
AS
EXEC("SELECT * FROM tblProvince WHERE " + @.whereClause)
RETURN
GO
However this isn't working, I am getting this error:
Incorrect syntax near 'SELECT * FROM tblProvince WHERE '.
Now I am guessing the EXEC statement must have changed, as every stored proc that uses the exec command errors out with this same error. All my other procedures run just fine. Can anyone please tell me how to fix it?
THanks
oh wow nm, i figured it out.. just replaced double quotes with single.sql
No comments:
Post a Comment