If you don't want to write UPDATE statements and you just want to manually modfiy few records in a table ,
Under Object Explorer ->right click on Tables -> Edit Top 'N' rows
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhncUMv5D7wN7-fta3etTo0SYfKkw18iS0wB1D012cnVKxHCSvnRA6Bfg20O0H8geqjLVxvZ1sx-jbQ-f6PagrKA8gQB3S2xEQZs1_6PcDU4lgY9335M3K-bSBcttVT-G44YDDib5g0uovE/s640/sms1.JPG)
For example,I will copy values from AddressLine1 and paste it on AddressLine2 for AddressID = 1,
click on some other row and run this query on new window
SELECT * FROM [Person].[Address] WHERE Addressid = 1
Under Object Explorer ->right click on Tables -> Edit Top 'N' rows
For example,I will copy values from AddressLine1 and paste it on AddressLine2 for AddressID = 1,
click on some other row and run this query on new window
SELECT * FROM [Person].[Address] WHERE Addressid = 1
you will notice modified value on AddressLine2 for AddressID = 1
To edit top 10,100,200 rows...you can adjust that settings
Tools - > Options - >SQL Server Object Explorer
After editing rows,like we copy the query resultsets,you can click on top row first column(0,0) copy & paste the results on excel sheet if you want to manually export modified records to excel.
No comments:
Post a Comment