Link to home
Start Free TrialLog in
Avatar of sbdt8631
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.
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I think you can, but you are a LOT better off modifying it through script:

update tablename
set fieldvalue = 'something'
where fieldvalue2 = 'something'
>>because internally it has to recreate the table

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
Avatar of sbdt8631
sbdt8631

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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial