SELECT TOP x field FROM
-
is the Select Top functionality or an alternative available in sql server 2000? if I have this data... 100 200 330 445 665 887 999 ...I know I can achieve it by ordering it and then using the if value > ALL ... but what if it is a lot more complicated than this? thanks
Visual Studio can't evaluate this, can you?
public object moo { __get { return moo; } __set { moo = value; } } -
is the Select Top functionality or an alternative available in sql server 2000? if I have this data... 100 200 330 445 665 887 999 ...I know I can achieve it by ordering it and then using the if value > ALL ... but what if it is a lot more complicated than this? thanks
Visual Studio can't evaluate this, can you?
public object moo { __get { return moo; } __set { moo = value; } }joon_ wrote:
is the Select Top functionality or an alternative available in sql server 2000?
Yes.
Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website
-
joon_ wrote:
is the Select Top functionality or an alternative available in sql server 2000?
Yes.
Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website
-
Which is it? SELECT TOP didn't exist before 2005, did it..?
Visual Studio can't evaluate this, can you?
public object moo { __get { return moo; } __set { moo = value; } }joon_ wrote:
SELECT TOP didn't exist before 2005, did it..?
Yes, it did. TOP was introduced in SQL Server 2000
Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website
-
joon_ wrote:
SELECT TOP didn't exist before 2005, did it..?
Yes, it did. TOP was introduced in SQL Server 2000
Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website
I found my problem, it seems that Select TOP has changed it's capabilities a lot in 2005, and this was the issue. Thanks. On a sidenote, I'm sorry for the poor quality of some of my posts, but I'm really just trying to learn and help people at the same time. Thank you for remaining professional and not just breaking down all of my ideas because you think I'm an idiot.
Visual Studio can't evaluate this, can you?
public object moo { __get { return moo; } __set { moo = value; } }