Re: SQL Statement length
From: ch (ch_at_dontemailme.com)
Date: 11/26/04
- Next message: Jacco Schalkwijk: "Re: Sub SELECT from the same table"
- Previous message: Jacco Schalkwijk: "Re: trace file created but not populated"
- In reply to: pehuan: "SQL Statement length"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 26 Nov 2004 08:36:57 -0600
depends on how you execute it.
max varchar is 8000 characters so if you're making a string watch out
for that.
if you're using exec(@string1) and need more than 8000 characters, split
your query into multiple strings and do exec(@string1 + @string2 +
@string3+...)
i've got an application that runs queries of over 20000 characters. the
query is around 15 unions. it's the nastiest select statement i've ever
seen.
pehuan wrote:
>
> What is the max length (if any) a SQL statment can have on SQL server 2000?
- Next message: Jacco Schalkwijk: "Re: Sub SELECT from the same table"
- Previous message: Jacco Schalkwijk: "Re: trace file created but not populated"
- In reply to: pehuan: "SQL Statement length"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
