December 7, 2008 at 9:11 pm
Hi All,
I have one Dot Net application. Previously we were using SQL Server 2000 but now we want to migrate it to SQL Server 2005. In this application we are generating one Select statement dynamically. For generating that select statement we are accessing perticular tables schema from database and by using column names of that table we are generating that select statement. It works fine if we are using SQL Server 2000 but it is not working for same table in 2005. It is not giving any error but it is not selecting any column. It creates statement like 'Select from'. Can anyone tell me what may be the problem? Is their any difference in access from Dot Net code in 2000 and 2005???
=======================================
[font="Tahoma"]"Dont let someone be priority in your life if you are simply option for someone."[/font]
December 7, 2008 at 9:44 pm
Show us the code.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2008 at 10:42 pm
Are selecting column names from information_schema.columns?
Try running only that query which is getting you the column names. Check whether is it returning column name.
Try running the query part by part & check where its breaking.
If you can post the code it would be helpful for us to help you.
December 8, 2008 at 2:14 am
Is their any difference in access from Dot Net code in 2000 and 2005???
No. There is no differece in access from .NET code for 2000 and 2005.
However, there are few differences in T-SQL syntax in 2000 and 2005. For example, outer join with * is not allowed in compitability level 90.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply