Boh!

BWFC (8/3/2015)

---

Not only do none of the answers appear to be correct but the the explanation does not match the options.

The correct answer is Query 2, with the MODIFY FILE...

I tested it. The qotd is right and also the answers are correct.

I learned something new.

I also tested placing a WITH(NOLOCK) on query 2 and 3, same results.

Query 1:

create table...

+1

Here, another dos command to list files, each column is separated by "*":

@for /R...

From BOL:

If you are running an edition of SQL Server that does...

I read about TEMPORAL TABLE just two weeks ago.

Good qotd!

🙂

Easy, thanks!

😀

Correct answer:

When J is between -999,999,999 and -100,000,000 or between 1,000,000,000 and 2,147,483,647

Correct explanation:

...

If the expression is between -999,999,999 and -1(,0)00,000,000 or between 1,000,000,000 and 2,147,483,647 it's decial representation...

I'm surprised, how an "answers bad worded" qotd gets more than 60% of right answers.

:crazy:

-- Using credentials on database requires enabling traceflag

DBCC TRACEON(4631,-1)

Instead of

-- Using credentials on database requires enabling traceflag

DBCC TRACEOFF(4631,-1)

deroby (6/18/2015)

---

I'm going to chime in on the 'Yay for sp_helptext' team.

The stored procedure might be old (and indeed in need for some TLC, thumbs up for the...

I fixed this bug in the sp_helptext in 2002 in SQL2000 in the same way. I changed the length from 255 to 4000, but the problem is not solved completely....

I thought that this statement was missing:

alter INDEX SalesArchive_CI_SalesPersonID ON dbo.SalesArchive disable

... and got it right!

😀

With ZEROS:

SELECT FORMAT(12354,'000-00-0000') AS 'SSN'

Returns "000-01-2354"

The fact that Microsoft uses cursors in many sp and functions is only because that codes have been written in earlier version of SQL, starting from 4.2 in '90.

So, except...