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.
| Author |
Topic |
|
ashu_bandhu
Starting Member
1 Post |
 Posted - 2006-05-18 : 03:29:51
|
| Hi All, I am having a problem in storing a data into a varchar. There is a stored procedure that adds the seven digit data plus an wild character comma to a variable of type varchar. Since the varchar has the storage capacity of 8000 characters the records beyond 8000 are lost! Is there any way I could store the data into a buffer directly insted of any variable or is there any other option I can try. For info I am working on SQL Server 2000 and the stored procedure is called my a session variable in a web page.Thanks in advanceAshu |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
SQL Server 2000 storage limitation