Monday, February 20, 2012

Query length

Hi,
Is length of sql query limited in MS_SQL Server ?
tia
pluton
Not specific limitation I can think off ...
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"pluton" <zielonadupa@.poczta.onet.pl> wrote in message
news:c7nj5p$kpm$2@.news.onet.pl...
> Hi,
> Is length of sql query limited in MS_SQL Server ?
> tia
> pluton
>
|||250 MB and 1024 tables per SELECT, not limits you're very likely to run
into.
Jacco Schalkwijk
SQL Server MVP
"pluton" <zielonadupa@.poczta.onet.pl> wrote in message
news:c7nj5p$kpm$2@.news.onet.pl...
> Hi,
> Is length of sql query limited in MS_SQL Server ?
> tia
> pluton
>
|||Hi,

> 250 MB and 1024 tables per SELECT, not limits you're very likely to run
> into.
Indeed. Thanks
pluton

No comments:

Post a Comment