Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gtabetnj
Starting Member
8 Posts |
 Posted - 2012-03-29 : 09:50:50
|
| I have now spent 9 hours looking through every control and button I cna find on studio manager to make an update query - has it been removed?Yes, I could write it by hand, but i see no reason not to have a standard interface for it as past versions of sql server have had.any clues? or maybe with 2012 we have such good data we never need to do updates to rows any morethanksgej |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
gtabetnj
Starting Member
8 Posts |
Posted - 2012-03-30 : 11:41:21
|
| I will differ with you on this.The purpose of a GUI is to avoid having to write code, not to just give a really fancy screen that you still have to hand-write all the code in.Also, a goo UI will allow you to construct the query in Select mode, assure that you are getting all the exact rows you expect, and the values you want to change to are appropriately reflected in a column, then switch it to update mode.As one who regularly has to work with supposed database experts, who willy-nilly execute statements, then say 'Oops - I didn't mean to update or delete those rows', I find a standard IT practice of using a gui to build a query as a Select and then changing it to an Update or Delete severely reduces the number of accidentsSo I Do expect a interface with a mojor tool like SQL server to allow you to visually construct standard update and delete queries, in addition to the standard selects.I do understand that corner case queries (unioned queries for example) are very difficult to visually represent in a GUI, so the need for manual adjustment to queries is also there, but standard Insert, Update, and delete queries should be modeled in a GUI, not hand written because the GUI couldn't handle itThanksBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxWant to help yourself?http://msdn.microsoft.com/en-us/library/ms130214.aspxhttp://weblogs.sqlteam.com/brettk/http://brettkaiser.blogspot.com/[/quote]gej |
 |
|
|
|
|
|
|
|
sql server 2012 - update queries?