Sorry but the "correct" answer is wrong. The insert into Numbers is:

INSERT dbo.Numbers (n, word) VALUES

(1, 'A '),

Note the white space after A, so the first word is "A "....

I think windows calculator gets it right if you use the +/- button for the negative numbers:

-100 ÷ -100 × 10 = 10

If you key in - before the 100s...

For many years at least in the UK the school system has been teaching "BODMAS" as the way to solve potentially ambiguous equations. The BBC educational assistance page about it:...

I once thought they were a good idea too...

until I needed to revise the underlying type definitions for a set of user defined data types in multi terrabyte production databases...

It is not a "heat map" because that implicitly required clustering - reducing the data values, which is why the Cran R project provides the pheatmap function.
The image...

I agree - it is the very first statement of the explanation!

These questions are starting to get ridiculous - options 1,2 and 3 shouldn't be used because they don't work, or may cause a minor performance hit or clash with existing...

The other potential "trap" is that depending on the collation settings (which were not mentioned) the LIKE operator can be case sensitive so the sentences starting with "Coffee" wouldn't match;...

I must be missing the explanation here?

This page https://msdn.microsoft.com/en-us/library/ms191530.aspx says that implicit conversion from char, varchar, nchar, nvarchar is supported to decimal, numeric, float, real, bigint, int, smallint,...

🙂

Because there is a Column called ClassSubject - a count of Classes in each Room (and Building) is a completely different question to a count of Subjects.

They are different types...

I agree; poor question with no correct answer. How can a count of rows in a table that lists Classes return a "count of subjects in each"?

A Subject...

This is a serious fault in a basic function in SQL Server; my conclusion is based on the behaviour on SQL Server of:

select ROUND(1.999, 2);

2.000

And Oracle 10g:

SELECT ROUND(0.999,2) from dual;

1

And...

I agree completely with Toreador on this - the query returns the two table names and the name of the foreign key constraint between them.

As the first two answers seem...

I beg to differ - practical experience says that the column list is a valid place to alias CTE columns, no matter what the documentation may say.

I don't have the...