Hello.

Sorry by my english.

Does anyone know how to use Text var in a SP? I need pass a long XML text to a SP.

Example:
DECLARE @v1 AS VarChar(8000)
DECLARE @v1 AS VarChar(8000)
DECLARE @ret AS Int
DECLARE @v3 AS Text -- Error
......
EXEC sp_xml_preparedocument @ret OUTPUT, @v1+@v2 -- Error

Thank you very much.