Viewing 15 posts - 1,366 through 1,380 (of 7,484 total)
Fairly straightforward question. I imagine the US Regional settings thing is just to say that '20130214" is interpreted as YYYYMMDD when converted to date and that the first day...
November 26, 2015 at 2:32 pm
Steve Jones - SSC Editor (11/25/2015)
Alvin Ramard (11/25/2015)
Steve Jones - SSC Editor (11/25/2015)
November 25, 2015 at 8:01 pm
Recce70 (11/25/2015)
They have not made a manual large enough with which to beat the developer / DBA who would create a table like this in Production.
Why would I want to...
November 25, 2015 at 7:47 pm
Brandie Tarvin (11/23/2015)
Luis Cazares (11/23/2015)
Is it me or many people don't really understand error handling or why and how to use try...catch...?
It's not just you. Though, to be fair, Try...Catch...
November 24, 2015 at 9:13 am
sknox (11/24/2015)
Hugo Kornelis (11/24/2015)
From the answer options I deduced that I...
November 24, 2015 at 8:45 am
Nice question.
But your "not necessarily recommended" is a bit less emphatic than my expression would be if I encountered something like this in a code review. :rolleyes:
November 23, 2015 at 9:36 pm
bsproat (11/20/2015)
BEGIN TRANSACTION;
UPDATE
MyTable
SET
test = 9;
COMMIT WORK2
GO
But this does
BEGIN TRANSACTION;
UPDATE
MyTable
SET
...
November 23, 2015 at 3:05 am
Luis Cazares (11/20/2015)
https://technet.microsoft.com/en-us/library/aa258231(v=sql.80).aspx
It's weird that this...
November 23, 2015 at 2:25 am
robert.sterbal 56890 (11/20/2015)
This is what I looked at:SELECT CURRENT_TIMESTAMP- SYSDATETIME() 'CURRENT_TIMESTAMP- SYSDATETIME()',
SYSDATETIME() 'SYSDATETIME()',
SYSDATETIMEOFFSET() 'SYSDATETIME()',
SYSUTCDATETIME() 'SYSUTCDATETIME()',
CURRENT_TIMESTAMP 'CURRENT_TIMESTAMP',
GETDATE() 'GETDATE()',
GETUTCDATE() 'GETUTCDATE()'
CURRENT_TIMESTAMP- SYSDATETIME() was either
1899-12-31 23:59:59.997
or
1900-01-01 00:00:00.000
You...
November 22, 2015 at 12:20 pm
jasona.work (11/20/2015)
If I recall from the MSDN page, the first three are a higher precision than the latter three, so that may account for some of the differences.
The lower precision...
November 20, 2015 at 1:03 pm
jasona.work (11/19/2015)
Just for Jeff Moden:How to get the date from SQL Server.
Sample data required: None
Queries:
SELECT SYSDATETIME();SELECT SYSDATETIMEOFFSET();
SELECT SYSUTCDATETIME();
SELECT CURRENT_TIMESTAMP();
SELECT GETDATE();
SELECT GETUTCDATE();
:hehe:
Was the syntax error deliverate? :hehe:
Of course having...
November 20, 2015 at 11:41 am
Oh dear, brain not working today, it seems to have entered lazy mode. Just answered last weeks create type question (correctly) and commented on the terminology (which MS seems...
November 17, 2015 at 5:11 am
Nice simple question.
But although it is nice and simple and it's easy to see which option is intended to be correct, pedantically speaking perhaps none of them is correct -...
November 17, 2015 at 5:02 am
BrainDonor (11/17/2015)
Lynn Pettis (11/16/2015)
BrainDonor (11/16/2015)
I've lost count of the number of times I've prepared the material to explain a question, only to have found the answer in doing so.
SSC is...
November 17, 2015 at 4:05 am
Viewing 15 posts - 1,366 through 1,380 (of 7,484 total)