Connect to another server in Query Analyzer

Hello,
Is it possible to connect to another server and database using code in the
query analyze?. I'm trying to do the equivalent of ctrl+O with the name of
the server and database.
Any help with this would be appreciated.
--
Thanks in advance,
sck10No, once you execute code in QA, you execute that code in the SQL Server you are connected to. In
SQL Server 2005, the successor to OSQL, called SQLCMD, will have that feature.
Changing database is simple, though, using USE.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:u%237htHskFHA.3164@.TK2MSFTNGP15.phx.gbl...
> Hello,
> Is it possible to connect to another server and database using code in the
> query analyze?. I'm trying to do the equivalent of ctrl+O with the name of
> the server and database.
> Any help with this would be appreciated.
> --
> Thanks in advance,
> sck10
>

Connect to another server in Query Analyzer

Hello,
Is it possible to connect to another server and database using code in the
query analyze?. I'm trying to do the equivalent of ctrl+O with the name of
the server and database.
Any help with this would be appreciated.
Thanks in advance,
sck10
No, once you execute code in QA, you execute that code in the SQL Server you are connected to. In
SQL Server 2005, the successor to OSQL, called SQLCMD, will have that feature.
Changing database is simple, though, using USE.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:u%237htHskFHA.3164@.TK2MSFTNGP15.phx.gbl...
> Hello,
> Is it possible to connect to another server and database using code in the
> query analyze?. I'm trying to do the equivalent of ctrl+O with the name of
> the server and database.
> Any help with this would be appreciated.
> --
> Thanks in advance,
> sck10
>
sqlsql

Connect to another server in Query Analyzer

Hello,
Is it possible to connect to another server and database using code in the
query analyze?. I'm trying to do the equivalent of ctrl+O with the name of
the server and database.
Any help with this would be appreciated.
Thanks in advance,
sck10No, once you execute code in QA, you execute that code in the SQL Server you
are connected to. In
SQL Server 2005, the successor to OSQL, called SQLCMD, will have that featur
e.
Changing database is simple, though, using USE.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:u%237htHskFHA.3164@.TK2MSFTNGP15.phx.gbl.
.
> Hello,
> Is it possible to connect to another server and database using code in the
> query analyze?. I'm trying to do the equivalent of ctrl+O with the name o
f
> the server and database.
> Any help with this would be appreciated.
> --
> Thanks in advance,
> sck10
>

connect by prior

Hello,
I have to migrate an application from oracle to sqlserver but i habe query with
connect by prior
What is the equivalent in sqlserver 2000.
Please help me.The CONNECT BY PRIOR syntax is an Oracle (and now DB2) specific add-on to the SQL-92 standard. Similar functionality is comming in Yukon, the next version of SQL Server, but for now you can write a User Defined Function in SQL-2000 to get the same effect.

-PatP|||The CONNECT BY PRIOR syntax is an Oracle (and now DB2)
-PatP

Not if you're stuck with V7 on OS/390...

Give me a big block V8 PLEASE!

Connect By Clause

Hi,
We have "Connect By Clause" as in Oracle. Do we have the same or equivalent in MS-SQL Server 2000?
Thanks with Regards.
-MohitCan you give some explaination about "Connect By Clause" in Oracle?|||There is no connect by equivalent in SQL 2000. It has been promised for SQL Yukon.

Connect by is a way of selecting a hierarchy of records from a table. If you have a table like

empID int
empName varchar(10)
MgrID int

You can select a manager, and all of his sub-employees (and their sub-employees, and so on..) by using a connect by query.|||It's an iterative process in sql server...

you need a loop..and you need to determine how many levels you need to go...