c#: sql and ? -- c#

Re: sql and ?

Fabio
3/12/2005 8:50:49 PM

c#: [quoted text, click to view]

How about create a sproc that takes two parameters (ntext and Image), start a
transaction, UPDATE ntext; if all goes well UPDATE Image, else rollback.

Also notice there's microsoft.public.dotnet.adonet where you might get more help...

--
Fabio Marini

sql and ?

perspolis
3/12/2005 9:23:52 PM

Hi all
I used SqlServer to manage my data.
SqlServer has a promlem in updating ntext and Image fields.
I have a table which includes some field like ntext and Image.
when I want to update this table,I get an error that says
"Can't update ntext and Image field together."
how can I update this table with one sql command.
I think I can update that columns separatedly...but it's not a good way.
looking for a good way.
thanks in advance