Tags » SQL

TSQL to find Databases, corresponding elastic pool names and DB edition - Azure

-- 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
SQL

[HOWTO] Create LocalDB File (.mdf) manually in Visual Studio 2015

If you are using LocalDB and want to create an empty database you should perform the following steps.

  1. Go to Visual Studio Server Explorer | …
  2. 94 more words
Various Products

IST and EST Time

You can show the difference in hours and minutes from Coordinated Universal Time (UTC), UTC + 05:30 is an identifier for a time offset from UTC of +05:30. 73 more words

SQL

SQL - Transactions

SQL – Transactions

A transaction is a unit of work that is performed against a database. Transactions are units or sequences of work accomplished in a logical order, whether in a manual fashion by a user or automatically by some sort of a database program. 1,076 more words

SQL

The difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN

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

SQL

SQL Server Management Studio...Customising those themes!

Howdy all,

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

Code

ZERO_DIVIDE ORA-01476

DECLARE
stock_price NUMBER := 9.73;
net_earnings NUMBER := 0;
pe_ratio NUMBER;
BEGIN
pe_ratio := stock_price / net_earnings;
dbms_output.put_line(‘Price/earnings ratio = ‘ || pe_ratio);
END;
/ 69 more words

SQL