|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL 2005 QuestionQuestion, I just came from an ms sql 2000 enviroment to the new 2005
sql server management studio. In 2000 enterprise manager, if I wanted to update some data quickly, I could expand the database tree on the left side of the app... right click on any table and select "Open as Query" type in my sql statement and then I could freely edit the returned results. When I try this in 2005, the nearest I can find by right clicking a table is "Script table as..." and then choose "Select to". I am not able to edit the results in this manner. I used to use this process all day long on 2000 enterprise manager and now I am at a complete loss! I know just enough about sql server to get my asp apps to run. Can someone tell me how best to acheive what I need to do in 2005 and provide a little step by step? Thanks in advance. Bill,
When you right-click on a table, the third option in the pop-up menu is Open Table. When you open the table, you can edit the data in SSMS. -- Show quoteDejan Sarka, SQL Server MVP Mentor, www.SolidQualityLearning.com Anything written in this message represents solely the point of view of the sender. This message does not imply endorsement from Solid Quality Learning, and it does not represent the point of view of Solid Quality Learning or any other person, company or institution mentioned in this message "bill_atwork" <bill_atwork2***@yahoo.com> wrote in message news:1159389393.253901.266410@d34g2000cwd.googlegroups.com... > Question, I just came from an ms sql 2000 enviroment to the new 2005 > sql server management studio. In 2000 enterprise manager, if I wanted > to update some data quickly, I could expand the database tree on the > left side of the app... right click on any table and select "Open as > Query" type in my sql statement and then I could freely edit the > returned results. When I try this in 2005, the nearest I can find by > right clicking a table is "Script table as..." and then choose "Select > to". I am not able to edit the results in this manner. I used to use > this process all day long on 2000 enterprise manager and now I am at a > complete loss! > > I know just enough about sql server to get my asp apps to run. Can > someone tell me how best to acheive what I need to do in 2005 and > provide a little step by step? > > Thanks in advance. > Yes I noticed that, but if I were looking for one specific record in a
table holding millions of records it is so much easier to just pull a query for example (Select * from mytable where email = someSpecificEmaillAddr***@email.com) and then update any field needing to be updated. Do they (microsoft) actually expect us to hunt through millions of records? There must be another way. Dejan Sarka wrote: Show quote > Bill, > > When you right-click on a table, the third option in the pop-up menu is Open > Table. When you open the table, you can edit the data in SSMS. > > -- > Dejan Sarka, SQL Server MVP > Mentor, www.SolidQualityLearning.com > Anything written in this message represents solely the point of view of the > sender. > This message does not imply endorsement from Solid Quality Learning, and it > does not represent the point of view of Solid Quality Learning or any other > person, company or institution mentioned in this message > > "bill_atwork" <bill_atwork2***@yahoo.com> wrote in message > news:1159389393.253901.266410@d34g2000cwd.googlegroups.com... > > Question, I just came from an ms sql 2000 enviroment to the new 2005 > > sql server management studio. In 2000 enterprise manager, if I wanted > > to update some data quickly, I could expand the database tree on the > > left side of the app... right click on any table and select "Open as > > Query" type in my sql statement and then I could freely edit the > > returned results. When I try this in 2005, the nearest I can find by > > right clicking a table is "Script table as..." and then choose "Select > > to". I am not able to edit the results in this manner. I used to use > > this process all day long on 2000 enterprise manager and now I am at a > > complete loss! > > > > I know just enough about sql server to get my asp apps to run. Can > > someone tell me how best to acheive what I need to do in 2005 and > > provide a little step by step? > > > > Thanks in advance. > > On 28.09.2006 16:20, bill_atwork wrote:
> Yes I noticed that, but if I were looking for one specific record in a Well, if you know what you want to change you can use "script as update"...> table holding millions of records it is so much easier to just pull a > query for example (Select * from mytable where email = > someSpecificEmaillAddr***@email.com) and then update any field needing > to be updated. > > Do they (microsoft) actually expect us to hunt through millions of > records? > > There must be another way. robert Try this:
1) Right-click a table, and then click Open Table. Pick a small table, so you have a quick response. 2) Right-click the open table (the empty gray box in the upper left corner is a good spot), point to Pane, and then click SQL. At this point the query opens and you can add a WHERE clause to restrict the output. If you picked some small table in step 1, just replace the table name with the desired table. You may also wish to click Diagram and Criteria to have a full query creation surface. 3) Run this modified query by clicking the ! on the toolbar, or press Ctrl+R. (No I don't know why they picked Ctrl+R??) Hope this helps. -- Show quoteRick Byham, MS This posting is provided "AS IS" with no warranties, and confers no rights. "Robert Klemme" <shortcut***@googlemail.com> wrote in message news:%237Jtpyw4GHA.696@TK2MSFTNGP06.phx.gbl... > On 28.09.2006 16:20, bill_atwork wrote: >> Yes I noticed that, but if I were looking for one specific record in a >> table holding millions of records it is so much easier to just pull a >> query for example (Select * from mytable where email = >> someSpecificEmaillAddr***@email.com) and then update any field needing >> to be updated. >> >> Do they (microsoft) actually expect us to hunt through millions of >> records? >> >> There must be another way. > > Well, if you know what you want to change you can use "script as > update"... > > robert Rick Byham, MS wrote:
> 3) Run this modified query by clicking the ! on the toolbar, or press Because of the R in "run", I would assume.> Ctrl+R. (No I don't know why they picked Ctrl+R??) I guess that the easiest way to explain it is that Enterprise Mangler
included what amounted to some user/client interfaces (e.g., Query Designer) that have not been exposed in SSMS. In my opinion, that makes SSMS a better product. -- Show quoteArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous "bill_atwork" <bill_atwork2***@yahoo.com> wrote in message news:1159453209.572650.186510@k70g2000cwa.googlegroups.com... > Yes I noticed that, but if I were looking for one specific record in a > table holding millions of records it is so much easier to just pull a > query for example (Select * from mytable where email = > someSpecificEmaillAddr***@email.com) and then update any field needing > to be updated. > > Do they (microsoft) actually expect us to hunt through millions of > records? > > There must be another way. > > > Dejan Sarka wrote: >> Bill, >> >> When you right-click on a table, the third option in the pop-up menu is >> Open >> Table. When you open the table, you can edit the data in SSMS. >> >> -- >> Dejan Sarka, SQL Server MVP >> Mentor, www.SolidQualityLearning.com >> Anything written in this message represents solely the point of view of >> the >> sender. >> This message does not imply endorsement from Solid Quality Learning, and >> it >> does not represent the point of view of Solid Quality Learning or any >> other >> person, company or institution mentioned in this message >> >> "bill_atwork" <bill_atwork2***@yahoo.com> wrote in message >> news:1159389393.253901.266410@d34g2000cwd.googlegroups.com... >> > Question, I just came from an ms sql 2000 enviroment to the new 2005 >> > sql server management studio. In 2000 enterprise manager, if I wanted >> > to update some data quickly, I could expand the database tree on the >> > left side of the app... right click on any table and select "Open as >> > Query" type in my sql statement and then I could freely edit the >> > returned results. When I try this in 2005, the nearest I can find by >> > right clicking a table is "Script table as..." and then choose "Select >> > to". I am not able to edit the results in this manner. I used to use >> > this process all day long on 2000 enterprise manager and now I am at a >> > complete loss! >> > >> > I know just enough about sql server to get my asp apps to run. Can >> > someone tell me how best to acheive what I need to do in 2005 and >> > provide a little step by step? >> > >> > Thanks in advance. >> > > Yes I had seen that but didn't know how to filter through millions of
records to find that one which needed to be edited. But I did a little more research and in that "Open table" view what I needed was the Ctrl + 1, Ctrl + 2, Ctrl + 3. Those panes give me everything I need. Thanks Dejan Dejan Sarka wrote: Show quote > Bill, > > When you right-click on a table, the third option in the pop-up menu is Open > Table. When you open the table, you can edit the data in SSMS. > > -- > Dejan Sarka, SQL Server MVP > Mentor, www.SolidQualityLearning.com > Anything written in this message represents solely the point of view of the > sender. > This message does not imply endorsement from Solid Quality Learning, and it > does not represent the point of view of Solid Quality Learning or any other > person, company or institution mentioned in this message > > "bill_atwork" <bill_atwork2***@yahoo.com> wrote in message > news:1159389393.253901.266410@d34g2000cwd.googlegroups.com... > > Question, I just came from an ms sql 2000 enviroment to the new 2005 > > sql server management studio. In 2000 enterprise manager, if I wanted > > to update some data quickly, I could expand the database tree on the > > left side of the app... right click on any table and select "Open as > > Query" type in my sql statement and then I could freely edit the > > returned results. When I try this in 2005, the nearest I can find by > > right clicking a table is "Script table as..." and then choose "Select > > to". I am not able to edit the results in this manner. I used to use > > this process all day long on 2000 enterprise manager and now I am at a > > complete loss! > > > > I know just enough about sql server to get my asp apps to run. Can > > someone tell me how best to acheive what I need to do in 2005 and > > provide a little step by step? > > > > Thanks in advance. > >  |
|||||||||||||||||||||||
Other interesting topics