Viewing 15 posts - 1 through 15 (of 54 total)
Corrected how?
You're still showing two invalid answers - CAST(SELECT '20161015 08:15 -4:25' as DATETIMEOFFSET) and SELECT '20161015 08:15 2:00'.
The solution is also confusing - the "correct answer" is option 2,...
November 11, 2016 at 12:25 pm
SQL-DBA-01 (3/18/2015)
Sorry, if I am confused, but the below link says:
"https://technet.microsoft.com/en-us/library/bb895334(v=sql.110).aspx"
SQL Server Express supports FILESTREAM. The 10-GB database size limit does not include the FILESTREAM data container.
So I selected...
March 18, 2015 at 10:05 am
SQLRNNR (6/2/2014)I am curious why you think this was an easy question.
The fact that it's almost identical to the question posted on 15th May helps! 🙂
http://www.sqlservercentral.com/questions/SQL+Server+2014/108889/[/url]
The date on that question...
June 2, 2014 at 9:04 am
I'm just hoping that, after last month's .NET updates broke SharePoint, they don't reintroduce the problem this month. It took them three weeks to release a patch for a single...
August 13, 2013 at 8:02 am
Your query using the CHECKSUM index is incorrect:
SELECT *
FROM dbo.PostalCode
WHERE PostalCheckSum = CHECKSUM(@PostalArea, @PostalCity, @PostalState);
As previously mentioned, the value returned from CHECKSUM will not be unique for the...
March 27, 2013 at 6:39 am
I'm still waiting for an explanation of why hundreds of perfectly valid bug reports were recently deleted. Even if they were closed as "won't fix", it was useful to know...
March 5, 2013 at 7:54 am
Also:
table variables can be used in functions, stored procedures, and batches.
December 18, 2012 at 6:34 am
--create table
CREATE TABLE [dbo].[Musician]
A perfect example of how not to write comments! 😛
October 29, 2012 at 8:35 am
Nice - a potential SQL injection vulnerability right inside your database! 😛
September 6, 2012 at 6:36 am
Steve Jones - SSC Editor (8/25/2012)
On the Windows platform, that system consists of 10mm lines of code ...
No wonder they've got so many LoC if they restrict the length of...
August 28, 2012 at 8:11 am
Another point to consider - what if the company hosting your data goes bankrupt? The receivers will likely turn off the servers abruptly, without giving you any time to extract...
April 12, 2012 at 6:48 am
Slight nit-picking issue: what is a "courser" lock? Do you mean a coarser lock?
March 19, 2012 at 7:29 am
You could also use single-user mode from the command-line, even if BUILTIN\Administrators is not in the sysadmin role:
March 7, 2012 at 6:27 am
One small issue - there is no "C#.NET"; it's just called "C#".
VB gained the ".NET" suffix to differentiate it from the pre-.NET versions, but C# was created at the same...
December 14, 2011 at 9:29 am
So a man who runs a company which sells a competitor to "oldSQL" products has given an interview saying the "oldSQL" is bad, and his "newSQL" competitor is doubleplusgood?
OK, I'll...
July 26, 2011 at 5:19 am
Viewing 15 posts - 1 through 15 (of 54 total)