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 |
|
tikiguy
Starting Member
6 Posts |
 Posted - 2007-05-09 : 12:53:57
|
| I would like to be able to use the Query Designer without having to close it out to test the query.I seem to recall using Query Designer in 2000 as a stand-alone app outside of Enterprise Manager.How can I use Query Designer AND have the results show up in the same window? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-09 : 14:32:14
|
| Query designer? You must be talking about Query Analyzer in SQL 2000.In SQL 2005, there is no separate tools like Query Analyzer, Enterprise Manager etc. Rather, everything is integrated under single development environment that is called Management Studio.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2007-05-09 : 16:01:27
|
| Well this feature is there in SQL SERVER Management Studio, you need to open the object browser and map the table. Then right click on the table click on the open tab, and then you will be able to see all the records. In menubar there are all the options of designing the queries.. somewhat similar to the EM in 2000..!!Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
|
|
|
Query Designer in SQL Server 2005