May 18, 2007 at 12:18 am
sounds like you need to learn the syntax of the UPDATE keyword
http://msdn2.microsoft.com/en-us/library/ms177523.aspx
---------------------------------------
elsasoft.org
May 18, 2007 at 8:10 am
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.
October 18, 2007 at 4:29 pm
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.
October 19, 2007 at 1:57 am
Cheers Scott that was brilliant......many thanks....:)
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy