Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: lele123
  • Content: Threads
  • Order by date
  1. lele123

    How to update multiple rows in MS SQL?

    My table looks like this: c1 c2 c3 a 1 2000 a 2 2001 a 3 3000 a 4 3001 a 5 3002 Step 1: delete rows where c3 = 2000, 2001 Delete table where c3 like '2___' Step 2: change 3000 to 2000, 3001 to 2001, 3002 to 2002, and so forth I'm stuck here. I'd appreciate any pointers or...

Part and Inventory Search

Back
Top