Home Forums SQL Server 2005 SQL Server 2005 Compact Edition SELECT STATEMENT DOESNT WORK WHEN IN C#, BUT WORKS IN VS2010 QUERY ANALYSER RE: SELECT STATEMENT DOESNT WORK WHEN IN C#, BUT WORKS IN VS2010 QUERY ANALYSER
camachorm
SSC Rookie
Points: 34
More actions
July 27, 2011 at 4:15 pm
#1359725
LOL, SQL CE Doesnt support views or SP... hence the dynamic query is required. I recently found the problem. In CE aliases arent supported in the WHERE clause... Go figure...