Viewing 15 posts - 241 through 255 (of 812 total)
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...
July 5, 2015 at 9:12 am
I'm surprised, how an "answers bad worded" qotd gets more than 60% of right answers.
:crazy:
July 2, 2015 at 1:58 am
-- Using credentials on database requires enabling traceflag
DBCC TRACEON(4631,-1)
Instead of
-- Using credentials on database requires enabling traceflag
DBCC TRACEOFF(4631,-1)
June 26, 2015 at 2:14 am
deroby (6/18/2015)
The stored procedure might be old (and indeed in need for some TLC, thumbs up for the...
June 18, 2015 at 3:41 pm
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....
June 18, 2015 at 9:45 am
I thought that this statement was missing:
alter INDEX SalesArchive_CI_SalesPersonID ON dbo.SalesArchive disable
... and got it right!
😀
June 10, 2015 at 1:32 am
With ZEROS:
SELECT FORMAT(12354,'000-00-0000') AS 'SSN'
Returns "000-01-2354"
June 3, 2015 at 1:59 am
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...
June 1, 2015 at 12:55 am
Easy, I used a lot in the past, sql 4.2 to sql2000. But there isn't a real need of cursors.
😀
May 22, 2015 at 1:34 am
pmadhavapeddi22 (5/20/2015)
Easy one
Easy, but batches are too long.
Query 3 and 4 differs only for the constant value.
May 20, 2015 at 1:59 am
Toreador (4/29/2015)
Only 54% correct? I was expecting close to 100%!
It depends if one has enough time to read correctly the question of th day.
April 29, 2015 at 1:27 am
If in the query there are many complex expressions, I prefer to name aliases in parenthesis.
April 28, 2015 at 1:12 am
Viewing 15 posts - 241 through 255 (of 812 total)