-- TSQL to find Databases, corresponding elastic pool names and DB edition SELECT @@SERVERNAME as , dso.elastic_pool_name, d.name as DatabaseName, dso.edition FROM sys.databases d inner join sys.database_service_objectives dso on d.database_id = dso.database_id WHERE d.Name <> 'master' ORDER BY d.name, dso.elastic_pool_name -- -- … 46 more words
Tags » SQL
If you are using LocalDB and want to create an empty database you should perform the following steps.
- Go to Visual Studio
Server Explorer| … 94 more words
INNER JOIN: returns rows when there is a match in both tables.
LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table. 415 more words
I am a bit of a customisation nut; pretty much with any software package I pick up I have the uncontrollable urge to dig straight into the options and get on the hunt for how to ‘theme it up’! 660 more words