Unfortunately I guess you will have no luck.

The nearest thing you could do is something like this:

DECLARE @myDbName sysname

SET @myDbName = 'Northwind'

EXEC ('USE ' + @myDbName + '; SELECT...

Exactly. So it depends on whether you want a table...

Hello R.

thanks for pulling out this information. It certainly helps most users get detailed insight into this topic.

I already knew these BOL explanations. Thats why I used 99.999999999 PERCENT...

Hi Colin,

I still think that order by in a view would make sense if the order by is the last step performed and the view is not joined to anything...

Thanks Ed! This was was really helpful.

May I ask you from where you got your knowledge?

Especially the parallel execution doesnt seem to be

well documented out in the net.

Hello Andy,

thanks for the article. But I think this only moves the problem around.

Archiving in my eyes means to move the data out of SQL Server.

Therefore I usually take the...

Hello Jeff,

Thanks very much for your answer first. But unfortunately this was exactly the type of answer I was trying to avoid. From what I can see my sample is...

It is a little difficult to answer correctly if there is no correct answer to choose.

I took my 50% chance to select the hidden 2383 out of the two 2382...

Hello,

 

this should give you the information you need:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=194277

 

Cheers,

Chris

Here's the official info from BOL:

Transact-SQL Joins

In earlier versions of Microsoft® SQL Server™ 2000, left and right outer join conditions were specified in the WHERE clause using the *=...

Hello,

I personally prefer the following method:

Import Data->Select source server and msdb -> select destination server and msdb -> Use a query

to specify the data to transfer -> SELECT *...