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 2005 Forums
 .NET Inside SQL Server (2005)
 Variable in stored procedure

Author  Topic 

nlenam
Starting Member

1 Post

Posted - 2008-05-16 : 04:44:03
Hi everybody, i have a problem and i hope anyone can help me.
I write a sp thayt include some variables. One of it is nvarchar(max) (because i think needed value is too big). Unfortunately, that variable is really too big (about 1000000 chars). It is out of bound of nvarchar(max). How can i do??
Please help me because i am working in it and it is too late now.
Thanks.

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-05-16 : 06:42:10
1000000 chars does not seem to be out of bounds for nvarchar(max). What error do you get?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

pragneshmpatel@gmail.com
Starting Member

3 Posts

Posted - 2008-05-29 : 10:29:36
Use Text at variable

Pragnesh
Go to Top of Page
   

- Advertisement -