July 15, 2013 at 12:49 pm
I recently found a quick way to do some data editing for a table with filter added.
That is from design view window from management studio.
when creating a new view, I can edit the data in the result panel.
is that a valid way of doing data modification?
Thanks,
July 16, 2013 at 1:58 am
You can modify data that way, but it is rather quick and dirty.
And you need to be sure your view is updateable.
I'd still prefer to write a decent update query.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2013 at 3:01 am
Sorry, I am not clear with your requirement 😉
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 16, 2013 at 10:28 am
Most of time I will use update query to do that.
But sometimes for some data entry issues, I found this is a quick way to edit the data quickly.
I don't really use the view, but in the view designer panel and the result panel, I found the data can be edited.
I know we can also edit some data in the table list, right click a table -edit top 200 rows, but sometimes I need to filter out some records, I found in the view designer, it is a quick way to do that.
July 16, 2013 at 12:09 pm
For a very small number of immediate changes, it's ok. But close the window immediately after the changes. If you let it hang open, you might cause issues with other queries.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
July 16, 2013 at 1:12 pm
sqlfriends (7/16/2013)
Most of time I will use update query to do that.But sometimes for some data entry issues, I found this is a quick way to edit the data quickly.
I don't really use the view, but in the view designer panel and the result panel, I found the data can be edited.
I know we can also edit some data in the table list, right click a table -edit top 200 rows, but sometimes I need to filter out some records, I found in the view designer, it is a quick way to do that.
If you are in the edit table screen, you can click on the little icon with SQL in it. It will show you the query and you can add filters that way. Using this method you don't have to write a view.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2013 at 1:19 pm
Thanks that is quite a little trick.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply