Rather odd functionality in Management Studio

Hi,

I have found some nice functionality in SQL Server Management Studio (I'm using the Developer Edition) that appears to me to be about reverse from what it should be.

If you start to create a View, the Query Designer opens. If you add a Parameter to your query, you get an error message saying that it is not valid in this type of query (of course). If you continue and then execute the query, a nice dialogue opens and invites you to enter the values to complete running the query. Nice, you can test your SQL. But of course you can't save. (You could cut and paste the tested SQL of course).

You get the same functionality when adding a query using VS2005 dataset designer, but here it is called the Query Builder! And without the error message of course.

On the otherhand, start to create a new Query, a text editor opens. Right click to start the Query Designer. Now write the same query, but there is no ability to run from the Designer. Close the designer, and if you try to run, you get an error message because the SQL is not parsed for the parameters!

Have others found this and thought it odd?

Thanks

John

Yes, this is odd and based ont he fact that the two UIs are own by different program groups at Microsoft. in further versions they will be aligned but until then you will have the different behaviour.

Jens K. Suessmeyer.

http://www.sqlserver2005.de