SSMS: easy way to update table after a select?

• Vera-428803

  SSCrazy

  Points: 2439

  More actions

  January 4, 2012 at 5:15 am

  #391241

  Hi forumfolks, I have a probably stupid question but it is a way of working that annoys me.

  It's about SSMS, you do a select on a table and then later on you want to do an update in the table.

  The way it seems to work now is that you select edit top 200, then edit the sql statement (with a where clause), then you can start updating. Which sounds a but cumbersome to me.

  If I compare it with enterprise server, there you can edit the query immediately and it was much easier.

  Am I doing something wrong or missing something that is obvious?

  Thanks for taking the time to respond.

  Vera

• Grant Fritchey

  SSC Guru

  Points: 398718

  More actions

  January 4, 2012 at 5:43 am

  #1428227

  What about just using the query window and typing 'UPDATE dbo.MyTable SET ColumnA = 42 WHERE ColumnB = 42'?

  The gui in SSMS can support what you're doing, but it's a pretty poor substitute for just using straight TSQL.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning