Dynamic Views in MSSQL Server - TechRepublic
General discussion
July 6, 2001 at 03:34 AM
shibu

Dynamic Views in MSSQL Server

by shibu . Updated 23 years, 5 months ago

MS-SQLServer provides varchar datatype of maximum size 8000 characters. The problem I am facing is that I am creating a dynamic view whose statements runs more than 8000 characters and I am not able to hold more than 8000 characters in a local variable whose data type is varchar(8000). SQL Server does not allow TEXT datatype as local variable which if allowed would solve the problem.How do I generate a dynamic view which is more that 8000 characters?

This discussion is locked

All Comments