Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 307
  • Last Modified:

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.
0
sbdt8631
Asked:
sbdt8631
  • 3
  • 2
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
you can do it thru ssms, but its not advisable because internally it has to recreate the table
0
 
chapmandewCommented:
I think you can, but you are a LOT better off modifying it through script:

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

really?
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
Aneesh RetnakaranDatabase AdministratorCommented:
>>>>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
0
 
sbdt8631Author Commented:
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.
0
 
chapmandewCommented:
you can right click the table and it will return 1000 records or so.  MS got away from what you were doing because it was such a resource hog.  
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now