Auto-Select Database Name

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ken Simmons SSCertifiable Points: 7822 More actions · Answer 1

You can put a use statement in the script.

Use database1

go

Select statment

Use database2

go

Select statement

Clive Strong SSChampion Points: 11222 More actions · Answer 2

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.

Carl Federl One Orange Chip Points: 25384 More actions · Answer 3

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

Carl Federl One Orange Chip Points: 25384 More actions · Answer 4

The command line was truncated:

isqlw.exe -S SqlServerName -D DatabaseName

SQL = Scarcely Qualifies as a Language

k man SSC-Addicted Points: 432 More actions · Answer 5

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