Cancel

Edit specific row(s) in Microsoft SQL Server Management Studio

Posted Apr 14, 2016 2016-04-14T00:00:00+08:00 by PipisCrew

Use the “Edit top 200” option,

snap356

then click on “Show SQL panel”, modify your query with your WHERE clause, and execute the query. You’ll be able to edit the results.

snap354

–

snap357

origin - http://www.pipiscrew.com/?p=4931 edit-specific-rows-in-microsoft-sql-server-management-studio

This post is licensed under CC BY 4.0 by the author.

Contents