Close the problems with the office door when you leave and leave them all behind. There is no more stressful experience then carry all the issues home and if you...

None of the formula options produced the expected result. The correct answer to this QOD is None of the answers is correct.

Hi Steve,

Which is your right piece of code:

A./

CREATE TABLE MyTable

( myid ID

, myFS varbinary(max) FILESTREAM

);

go FROM THE SQLServerCentral.com <subscriptions@sqlservercentral.com>

OR

CREATE TABLE MyTable

( myid INT

, myFS varbinary(max) FILESTREAM

);

go

from THE

No difference. Steve made a mistake. Can happen with anyone.

Hi Steve, the first and the sixth SELECT statement are the same: Should not be 5 is the correct answer?

1st Query:

SELECT mynum AS test

FROM dbo.myTable AS mt;

6th Query:...

Hi Steve, did you proof read this article before posting it. I got used to from you brilliant ideas, samples and solutions to follow, but this latest effort of yours...

Sorry guys and gals but I am really sad to find that so many wrong answers I am finding lately for the QOD (Question of the day). It would make...

Sorry but the response of the Which server collations are supported in Polybase SQl Server 2016 in SQLServercental is wrong or they don't read MSDN. The correct answer is what...

All tree answers are unrelated to the question of your exercise, i.e.: you are asking quote "What does this code return? " unquote and in all of the three answers...

Well said Steve.

Msg 217, Level 16, State 1, Procedure Test, Line 5

Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

And line 5 is the 5th line of the first...

Executing your script in SQL 2008 R2 and SQL 2012 SSMS without the "tmp" schema is created I was getting the following message:

Msg 2760, Level 16, State 1, Line 1

The...

Thank you Andrew. I lived and worked for 25 years in the belief, (Thanks to various Microsoft literatures like TECHNET, SQL BOL, etc...), that integer types on various SQL Server...

So I have a point and I don't have a point. Microsoft ohhhhh!!!!

Julien

Hi Steve this question of IDENTITY column data type your answer is wrong. The correct answer is quoted from http://msdn.microsoft.com/en-AU/library/ms189838.aspx:

IDENTITY (Function) (Transact-SQL) data type

Valid data...