Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by vibs
-
DVD-player region code...
hi b ..,.,.,. did you find out how to unlock your region code on your mac lab- vibs
- Post #2
- Forum: Macs and iPhones
-
How to store more than 8000 characters in a variable
Nope. "A variable cannot be of text, ntext, or image data type."- vibs
- Post #3
- Forum: Microsoft SQL Server: Programming
-
How to store more than 8000 characters in a variable
This is the stored procedure I wrote but the limitation is if the XML returned to me is more than 8000 characters, the XML gets truncated. Is there a way around this limitation? Many Thanks CREATE PROCEDURE DBO.SV_JobDetailAddl4XML ( @TransID INT ) AS BEGIN declare @xmltext varchar(8000)...- vibs
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
