Maximum statement length (SQL &/2000)

[EdVassie]

What is the mximum length for a SELECT statement, and for a CREATE VIEW statement.

Are there different limits in SQL 7 and SQL 2000, or in different editions of these products?

I have seen reference to a maximum SELECT statement length of 8000 characters. If true, this could be a problem as we need to create complex statements/views that will need over 12k characters in the SELECT or CREATE VIEW statement.

Disclaimer: All information given is a personal opinion that may not match reality. This posting is a personal opinion only, and may not reflect reality.

 

[aalmeida]

There is no limit to the number of characteres or lengh on a SELECT or CREATE VIEW Statment.
Such limitations are data types limitation as on variables declaration as in Declare @Sql varchar(8000) but even here you if you need 12k you could Declare @Sql varchar(8000) @Sql2 varchar(4000) voila 12k lengh is now available. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"