sbdt8631
asked on
Edit data MS SQL 2005
Is it still possible to directly edit data in a table in MS SQL 2005. If I needed to change one value in 2000, I would create a simple query on that table in Enterprise Manage to display the data I was interested in and then just change the values in the fields. Is there still a way to do that in 2005. The only way I have been able to figure out is to open the table and scroll until I find the row I need. This is very inconvenient.
Thank you.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>because internally it has to recreate the table
really?
really?
>>>>because internally it has to recreate the table
oopts what i was supposed to mention was about the locks and accidently put recreation, thanks tim
oopts what i was supposed to mention was about the locks and accidently put recreation, thanks tim
ASKER
aneeshattinqal:
I can do it through ssms if I open the table and scroll until I find the correct record, which is inconvenient when even possible. Is there a way to limit the records displayed like I used to do in 2000 where I created a query and edited the results of the query. I prefer not to write an update query for jobs where I only want to change one field in one or two records. I have a nasty habit of forgetting to include that pesky where clause. And there doesn't seem to be a simple way to copy a table like there was in 2000 for a simple backup in case of a mistake.
I can do it through ssms if I open the table and scroll until I find the correct record, which is inconvenient when even possible. Is there a way to limit the records displayed like I used to do in 2000 where I created a query and edited the results of the query. I prefer not to write an update query for jobs where I only want to change one field in one or two records. I have a nasty habit of forgetting to include that pesky where clause. And there doesn't seem to be a simple way to copy a table like there was in 2000 for a simple backup in case of a mistake.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
update tablename
set fieldvalue = 'something'
where fieldvalue2 = 'something'