A Stupid SQL Prototyping Question
-
Question: In VS.Net 2003, how do you get to a simple SQL prototyping window or the Query Designer without doing so in the context of a specific table or as part of the definition of a component. Here's what I've tried in order to answer the question myself: I've been using Query Analyzer from my SQL Server 200 install. I thought, "Hey, VS.Net has that built in. Why not use that?" 1. Wouldn't "Tools" be the logical place for something like that? Evidnetly not. 2. So, I have "Query" checked off in my Toolbars selections and I can see it but it's greyed out. 3. I go to the Server Explorer and fool around in there for a bit, right clicking everything in sight. The SQL (and most other buttons) on the Query tool bar remain inaccessible. 4. I go to Help. Why isn't there a "What's This?" like in the Office products. Now I'm in the locally installed MSDN off the CDs. I finally find "Help [Visual Studio.Net]", click it and (drum roll) "Empty Index Entry". 5. I connect to the Internet and go to MSDN Online. After a few minutes I'm at the MSDN Library and Visual Studio.Net. 6. I select "Visual Database Tools". Basically, at list of links with a one sentence explination. 7. I try "Database Queries and Visual Database Tools". Another list, no info. 8. Ok, "Query and View Designer". How to use it, what the components are. NO CLUE AS TO HOW TO GET THERE. And that's not even what I really want to know. WTF?! And on and on and on. I wasted 1/2 and hour searching. I'm anrgy, frustrated, and lost my whole train of concentration. And all I want to do is use one of the very simplest features. 9. Finally, I went back and after fooling around a while, I found that AT THE TABLE LEVEL there is a "Retrieve Data From Table". But before you have a chance to filter, it retrieves EVERY COLUMN of EVERY ROW. That's rediculous. Thanks for any non-crude suggestions, Will
-
Question: In VS.Net 2003, how do you get to a simple SQL prototyping window or the Query Designer without doing so in the context of a specific table or as part of the definition of a component. Here's what I've tried in order to answer the question myself: I've been using Query Analyzer from my SQL Server 200 install. I thought, "Hey, VS.Net has that built in. Why not use that?" 1. Wouldn't "Tools" be the logical place for something like that? Evidnetly not. 2. So, I have "Query" checked off in my Toolbars selections and I can see it but it's greyed out. 3. I go to the Server Explorer and fool around in there for a bit, right clicking everything in sight. The SQL (and most other buttons) on the Query tool bar remain inaccessible. 4. I go to Help. Why isn't there a "What's This?" like in the Office products. Now I'm in the locally installed MSDN off the CDs. I finally find "Help [Visual Studio.Net]", click it and (drum roll) "Empty Index Entry". 5. I connect to the Internet and go to MSDN Online. After a few minutes I'm at the MSDN Library and Visual Studio.Net. 6. I select "Visual Database Tools". Basically, at list of links with a one sentence explination. 7. I try "Database Queries and Visual Database Tools". Another list, no info. 8. Ok, "Query and View Designer". How to use it, what the components are. NO CLUE AS TO HOW TO GET THERE. And that's not even what I really want to know. WTF?! And on and on and on. I wasted 1/2 and hour searching. I'm anrgy, frustrated, and lost my whole train of concentration. And all I want to do is use one of the very simplest features. 9. Finally, I went back and after fooling around a while, I found that AT THE TABLE LEVEL there is a "Retrieve Data From Table". But before you have a chance to filter, it retrieves EVERY COLUMN of EVERY ROW. That's rediculous. Thanks for any non-crude suggestions, Will
There is no query analyzer in VS.NET 2003 IDE, but you can use the server explorer (this is like an enterprise manager in sql). 1. goto menu option "TOOLS" 2. select "Connect to Database" 3. Fill-out the SQL Authentication diaglog to open the server explorer regards,