|
Home > Archive > MS SQL Server > December 2006 > Server Mgmt Studio question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
| |
| Aaron Bertrand [SQL Server MVP] 2006-12-13, 7:12 pm |
| > 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?
| |
| Tibor Karaszi 2006-12-13, 7:12 pm |
| > 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.
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.
--
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 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
| |
| Aaron Bertrand [SQL Server MVP] 2006-12-13, 7:12 pm |
| 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.
| |
| Tibor Karaszi 2006-12-13, 7:12 pm |
| Ahh, I see.
I've never used those features (view designers and such) in SSMS, which perhaps 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 message
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.
>
>
>
>
| |
| Arnie Rowland 2006-12-13, 7:12 pm |
| 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
|
|
|
|
|