General discussion
-
Topic
-
Dynamic Views in MSSQL Server
LockedMS-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?
All Comments
Viewing 1 reply thread