• Post Reply Bookmark Topic Watch Topic
  • New Topic

multiple column update / Sybase  RSS feed

 
Brusk Baran
Ranch Hand
Posts: 132
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Salut comrades,
I have to make a complicated updated to a temporary table, which will be nourished with data from around 5 tables.(db= Sybase 12.5)

whatever i've tried, get always errors warning about Incorrect syntax near '('. seems that I MUST update the columns one by one.. is it so?
regards,
[ November 26, 2003: Message edited by: Brusk Baran ]
[ November 26, 2003: Message edited by: Brusk Baran ]
 
Brusk Baran
Ranch Hand
Posts: 132
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It seems that a simultaneous multiple column update to a table is not possible. Instead one by one....
create index ...... with ignore_dup_key is also very helpful.. to insert new rows without thinking of duplications, they are ignored implicitly.
This was helpful in my problem.
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!