Disable TOP

Dear all,
It's possible disable TOP operator?The only way that i have found is set
the compatibility to 6.5 but......
Thanks!!!!!!
That's the only way. BTW, why would you want to do this?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Stefano_PITECO" <Stefano_PITECO@.discussions.microsoft.com> wrote in message
news:FB886D3B-8E16-4D60-AC85-A16974A63EB4@.microsoft.com...
Dear all,
It's possible disable TOP operator?The only way that i have found is set
the compatibility to 6.5 but......
Thanks!!!!!!
|||Stefano_PITECO wrote:
> Dear all,
> It's possible disable TOP operator?The only way that i have found is set
> the compatibility to 6.5 but......
> Thanks!!!!!!
You could try using SET FIPS_FLAGGER. See Books Online for details.
This will generate warnings for a lot of other stuff too.
David Portas
SQL Server MVP
|||Strange requirement :-D No that not posssible...
Why do you wanna do this ?
HTH, Jens Suessmeyer.
|||Top is one of the most important field of my database....
"Tom Moreau" wrote:

> That's the only way. BTW, why would you want to do this?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "Stefano_PITECO" <Stefano_PITECO@.discussions.microsoft.com> wrote in message
> news:FB886D3B-8E16-4D60-AC85-A16974A63EB4@.microsoft.com...
> Dear all,
> It's possible disable TOP operator?The only way that i have found is set
> the compatibility to 6.5 but......
> Thanks!!!!!!
>
|||So what you're saying is that TOP is a column name? Ouch. It'll mean that
you'll have to change all references to use [TOP] - or you'll have to change
the column name and then change all references to use that.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Stefano_PITECO" <Stefano_PITECO@.discussions.microsoft.com> wrote in message
news:9B742642-294F-401C-87A0-5654F4C261F0@.microsoft.com...
Top is one of the most important field of my database....
"Tom Moreau" wrote:

> That's the only way. BTW, why would you want to do this?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "Stefano_PITECO" <Stefano_PITECO@.discussions.microsoft.com> wrote in
> message
> news:FB886D3B-8E16-4D60-AC85-A16974A63EB4@.microsoft.com...
> Dear all,
> It's possible disable TOP operator?The only way that i have found is set
> the compatibility to 6.5 but......
> Thanks!!!!!!
>
|||Stefano_PITECO wrote:
> Top is one of the most important field of my database....
>
This is on reason why column naming standards are important. Avoid
using reserved words as column names. Either change the name of the
column or make sure you always delimit TOP with square brackets.
David Portas
SQL Server MVP
|||Try using square brackets
SELECT TOP 10
[top]
, [ColumnB]
FROM
SomeTable
Should/might work.
Adrian
David Portas wrote:
> Stefano_PITECO wrote:
>
> This is on reason why column naming standards are important. Avoid
> using reserved words as column names. Either change the name of the
> column or make sure you always delimit TOP with square brackets.
>