Server Mgmt Studio question

Trying to get functionality of mysql query browser to work in similar
manner with mssql Server mgmt studio.

Using mysql query browser I can enter many statements and as long as
they are terminated with a semicolon they can all exist in the query
window. I can move from statement to statment by just moving the cursor
and hitting the execute button.

When I try doing this with MS Server Mgmt Studio it 'seems' that I can
only have one statement in the window at a time. I have a hard time
believing that is so.... so I must not be doing something correctly. How
do I get the same functionality from Mgmt Studio query browser?

TIA

> When I try doing this with MS Server Mgmt Studio it 'seems' that I can
> only have one statement in the window at a time.

In what window?  Did you right-click your database and select New Query?  Or
did you get what you think is a "query window" by doing something silly,
like right-clicking a table, choosing "Open Table," and then clicking on the
fancy SQL button?

> When I try doing this with MS Server Mgmt Studio it 'seems' that I can only have one stat
ement in
> the window at a time.

Why do you say that? When I open a query window, I can type as many TSQL com
mands as I wish. If I
only want to execute some of the TSQL commands in the window, I mark that te
xt and hit execute. If I
don't mark any text, then all commands in the window will be executed when I
 hit execute.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/


"user" <someone@someplace.org> wrote in message
news:qRWfh.485028$QZ1.241027@bgtnsc04-news.ops.worldnet.att.net...
> Trying to get functionality of mysql query browser to work in similar mann
er with mssql Server
> mgmt studio.
>
> Using mysql query browser I can enter many statements and as long as they 
are terminated with a
> semicolon they can all exist in the query window. I can move from statemen
t to statment by just
> moving the cursor and hitting the execute button.
>
> When I try doing this with MS Server Mgmt Studio it 'seems' that I can onl
y have one statement in
> the window at a time. I have a hard time believing that is so.... so I mus
t not be doing something
> correctly. How do I get the same functionality from Mgmt Studio query brow
ser?
>
> TIA

I think he is talking about Open Table / SQL view, or view designer, or one
of the other sub-par query tools in the product.  But not the standard query
window that you get from New Query.


> Why do you say that? When I open a query window, I can type as many TSQL
> commands as I wish. If I only want to execute some of the TSQL commands in
> the window, I mark that text and hit execute. If I don't mark any text,
> then all commands in the window will be executed when I hit execute.

Ahh, I see.
I've never used those features (view designers and such) in SSMS, which perh
aps can serve as an
excuse that I didn't catch that... ;-)

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/


"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in mess
age
news:OJQBuGuHHHA.960@TK2MSFTNGP04.phx.gbl...
>I think he is talking about Open Table / SQL view, or view designer, or one
 of the other sub-par
>query tools in the product.  But not the standard query window that you get
 from New Query.
>
> 
>
>

Highlight the query you wish to execute, and click on the EXECUTE button (or
hit F5).

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"user" <someone@someplace.org> wrote in message
news:qRWfh.485028$QZ1.241027@bgtnsc04-news.ops.worldnet.att.net...
> Trying to get functionality of mysql query browser to work in similar
> manner with mssql Server mgmt studio.
>
> Using mysql query browser I can enter many statements and as long as they
> are terminated with a semicolon they can all exist in the query window. I
> can move from statement to statment by just moving the cursor and hitting
> the execute button.
>
> When I try doing this with MS Server Mgmt Studio it 'seems' that I can
> only have one statement in the window at a time. I have a hard time
> believing that is so.... so I must not be doing something correctly. How
> do I get the same functionality from Mgmt Studio query browser?
>
> TIA