Hi,
I am building sql query dynamically, I declared @sql nvarchar(4000). Query builds more than 4000 characters. It prints upto 'where' clause and error out with syntax.
How shall I declare more than 4000 characters. If i declare ntext or text it gives error :
Error 2739 the text,ntext,and image data types are invalid for local variables.
Thanks for any help.
Here is my procedure
CREATE procedure test
@id nvarchar(255)
as
declare @sql narchar(4000)
set @sql='select a.id, -- so many fields
from table a LEFT OUTER JOIN table b
on a.id = b.id
where id = '+@id+
Print (@sql)
Execute (@sql)
GO
I am building sql query dynamically, I declared @sql nvarchar(4000). Query builds more than 4000 characters. It prints upto 'where' clause and error out with syntax.
How shall I declare more than 4000 characters. If i declare ntext or text it gives error :
Error 2739 the text,ntext,and image data types are invalid for local variables.
Thanks for any help.
Here is my procedure
CREATE procedure test
@id nvarchar(255)
as
declare @sql narchar(4000)
set @sql='select a.id, -- so many fields
from table a LEFT OUTER JOIN table b
on a.id = b.id
where id = '+@id+
Print (@sql)
Execute (@sql)
GO