Auto-Select Database Name

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Newbies » Auto-Select Database Name

Auto-Select Database Name

Rate Topic

Display Mode

Topic Options

Author

Message

gillygilligan84

Posted Friday, July 04, 2008 8:39 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 06, 2011 6:53 AM
Points: 172, Visits: 45

I have several databases to select from and each time I have to use the drop down menu to select the database I need. Is there any way of declaring which database I want to use without using the drop down menu?

Post #528693

KenSimmons

Posted Friday, July 04, 2008 8:49 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:07 AM
Points: 1,221, Visits: 2,614

You can put a use statement in the script.

Use database1
go
Select statment

Use database2
go
Select statement

Ken Simmons
http://twitter.com/KenSimmons

Post #528699

Clive Strong

Posted Friday, July 04, 2008 10:42 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 13, 2013 10:12 AM
Points: 959, Visits: 6,341

Just qualify the database in the FROM clause.

SELECT Col1, Col2
FROM TestDB1.dbo.MyTable

SELECT Col5, Col10, Col7
FROM DifferentDB.dbo.AnotherTable

Run the queries and you'll be querying the databases without the need to change the database manually or use the USE syntax.

Post #528726

Carl Federl

Posted Friday, July 04, 2008 11:25 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 3:55 PM
Points: 2,224, Visits: 4,079

You can also create a shortcut to Query Analyzer that will automatically connect to a specific server and database. The command line is:

isqlw.exe -S

You can also add -E for Integrated Security or "-U -P" to hard code a login and password.

SQL = Scarcely Qualifies as a Language

Post #528738

Carl Federl

Posted Friday, July 04, 2008 11:27 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 3:55 PM
Points: 2,224, Visits: 4,079

The command line was truncated:

isqlw.exe -S SqlServerName -D DatabaseName

SQL = Scarcely Qualifies as a Language

Post #528739

k man

Posted Friday, February 11, 2011 11:26 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, September 14, 2012 2:11 PM
Points: 227, Visits: 133

You can always change your default database to one you use the most...

Post #1062753

« Prev Topic | Next Topic »

Permissions