Viewing 15 posts - 1,366 through 1,380 (of 7,483 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...
Tom
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)
Tom
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...
Tom
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...
Tom
November 24, 2015 at 9:13 am
sknox (11/24/2015)
Hugo Kornelis (11/24/2015)
From the answer options I deduced that I...
Tom
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:
Tom
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
...
Tom
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...
Tom
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...
Tom
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...
Tom
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...
Tom
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...
Tom
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 -...
Tom
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...
Tom
November 17, 2015 at 4:05 am
Viewing 15 posts - 1,366 through 1,380 (of 7,483 total)