Intrebari

Re: convert nvarchar to text

crestinul — Sun, 28 Oct 2007 17:12:04 GMT

mai vezi si operatorul cast as

Re: convert nvarchar to text

Diana — Wed, 24 Oct 2007 09:06:28 GMT

Daca lucrezi pe SQL 2000 foloseste UPDATETEXT - ai un exemplu aici:

http://michaelsync.net/2006/07/04/sql-2k-tips-updatetext

Detaliile de sintaxa (destul de "dezagreabile" ) sunt in BOL

Daca lucrezi pe SQL 2005 foloseste varchar(max).

convert nvarchar to text

Abadon83 — Wed, 24 Oct 2007 08:46:18 GMT

vreau sa convertesc un nvarchar in tex

select +i.text+' ,'+i.tel+' ,'+convert(nvarchar(11),i.data_anunt,104)
from tbldiverse i
where data_anunt+28>=getdate() order by i.text,i.tel,i.data_anunt

i.text e de tip text

i.tel e nvarchar

am incercat select i.text+', '+ convert(text,i.tel) da nu merge

Msg 402, Level 16, State 1, Line 1
The data types text and varchar are incompatible in the add operator.

cum concatenez un text cu un nvarchar sau varchar?