sql and ?

  • Thread starter Thread starter perspolis
  • Start date Start date
P

perspolis

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
 
perspolis said:
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
Click to expand...

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...
 
Back
Top