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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Var Type in declare

Author  Topic  JasonB Starting Member 2 Posts Posted - 2001-11-02 : 05:03:18 Sorry if this is a beginner question How do I declare a SQL statement that is over 1000 characters? eg DECLARE @SQLStatement varchar(1500) I cant use ntext? text? Is there a trick to this one ? :) Thanks