SQL 2005 and Editing Data

Question

Post reply

SQL 2005 and Editing Data

Shin-435317

SSC-Addicted

Points: 432
More actions
May 15, 2007 at 4:17 am

#68831

Hi All
Iam using SQL 2005 and wrote a basic query, when the data returned I wanted to change some data in the sense edit the data. Previously I was able to do this in SQL 2000 and in EM.
How do I do this in SQL 2005?
Many thanks in advance

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

jezemine SSCrazy Eights Points: 8059 More actions · Answer 1

sounds like you need to learn the syntax of the UPDATE keyword

http://msdn2.microsoft.com/en-us/library/ms177523.aspx

---------------------------------------
elsasoft.org

Steve Jones - SSC Editor SSC Guru Points: 736254 More actions · Answer 2

If you did it in the EM editor, I don't think you can do that in SSMS. UPDATE is the way to do this.

Scott Clark-275269 Ten Centuries Points: 1221 More actions · Answer 3

you can do this in Management Studio it just isn't as straight forward. You have to:

1. Open the table by right clicking and selecting "open table"

2. press the SQL button in the query designer toolbar

3. build your query and execute

4. edit your data in the results window

Although this is possible it is the least favorable solution to your update needs as you don't have the option of containing your update in a transaction and performing any error validations.

Shin-435317 SSC-Addicted Points: 432 More actions · Answer 4

Cheers Scott that was brilliant......many thanks....:)