Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sona
Yak Posting Veteran
68 Posts |
 Posted - 2001-12-31 : 02:21:05
|
| Hello all, What is max length of SQL Statement that is acceptable to SQLServer via OLEDB? |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-31 : 03:07:02
|
| i myself have tried pretty looooooooooong 1's without any problem.never thought there is any such limit.if you use ODBC and connect it to Sql Server ,you will find a option "Save long running Queries to Log file" , i think that makes me feel you can go for very long queries in ODBC.did you come across any such error which indicates you have reached the maximum?.Did you check your Network Settings? |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-01-03 : 15:44:24
|
Max Length, as in number of characters in the statement that you are issuing? This is never a worry with stored procedures.  --------------------------------------------------------------1000 Posts, Here I come! I wonder what my new title will be... |
|
|
|
|
|
|
MAx Length