Re: Max length of a query string
- From: "William \(Bill\) Vaughn" <billvaRemoveThis@xxxxxxxxx>
- Date: Fri, 13 Apr 2007 13:13:44 -0700
It's 64K * Network Packet size which defaults to 4K. I think it's been 64K
(at least) for some time now. A limit of 256 means that you would have some
difficulty building an INSERT or UPDATE statement that had lots of strings
or a SP of any size at all...
See
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/13e95046-0e76-4604-b561-d1a74dd824d7.htm
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@xxxxxxxxxxxxxxxxxx> wrote in
message news:EF5F9231-A137-4252-B183-99E1F4C3B639@xxxxxxxxxxxxxxxx
Used to be 256 characters, but I am not sure whether that still is the
limit, or not.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
*********************************************
Think outside the box!
*********************************************
"Lubomir" <Lubomir@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D69D5A67-D3BD-42BF-A6A3-CFE1C627BCAE@xxxxxxxxxxxxxxxx
Hi,
I am wondering, is there any limitation for the length of a query string?
Thanks,
Lubomir
.
- Follow-Ups:
- Re: Max length of a query string
- From: Cowboy \(Gregory A. Beamer\)
- Re: Max length of a query string
- Prev by Date: Re: Advantage of Parameters
- Next by Date: Re: Advantage of Parameters
- Previous by thread: Advantage of Parameters
- Next by thread: Re: Max length of a query string
- Index(es):
Relevant Pages
|
Loading
