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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL7 text -> ntext convert error
I'm using stored procedure. CAST doesn't accept text, ntext or image as argument, and I can't declare input parameter as varchar or nvarchar because the size of data could be larger than 8(4)K. Explicit conversion in VB didn't help me much also, at least the following code: txtdata =...- dankes
- Post #3
- Forum: Microsoft SQL Server: Programming
-
SQL7 text -> ntext convert error
Hello guys. I'm using SQL7 on Win2k Server SP2 , VB6, ADO 2.5 Default language - English. I have the table something like that: Create Table SomeTable ( MsgID int identity(1,1), XUIDL nvarchar(255), From nvarchar(255), ... [other stuff] .... MsgBody ntext ) It is used to store parsed MIME...- dankes
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
