Viewing 15 posts - 106 through 120 (of 819 total)
DTUs provide a way to describe the relative capacity of a performance level based on a blended measure of CPU, memory, and read and...
March 22, 2018 at 2:32 am
bevanward - Saturday, March 17, 2018 11:21 AMComments posted to this topic are about the item Set-Based String Splitting table function
You ...
March 19, 2018 at 3:28 am
March 15, 2018 at 10:43 am
"The // operator is an integer division operator" that's false (-20). It's a FLOOR division (-21).
Learn the Syntax
March 14, 2018 at 2:21 am
Jeff Moden - Thursday, March 1, 2018 3:42 PMRIGHT(SomeIntZip+100000,5)
It's my favorite
March 2, 2018 at 1:24 am
SELECT FORMAT(COUNT(*),'#')
FROM HolydaysToDo
WHERE HolydaysToDo.Name = 'Steve Jones'
The result:
Arithmetic overflow error...
March 1, 2018 at 12:52 am
set CONTEXT_INFO 55
SELECT cast(substring(CONTEXT_INFO(),1,4) as int)
February 27, 2018 at 12:59 am
February 1, 2018 at 10:15 am
Steve Jones - SSC Editor - Thursday, February 1, 2018 7:46 AMCorrected the answers. Not sure what I was thinking while typing.
......
February 1, 2018 at 7:58 am
GRANT VIEW SHOWPLAN to JoeDevMsg 102, Level 15, State 1, Line 1
Incorrect syntax near 'VIEW'.
February 1, 2018 at 1:30 am
January 8, 2018 at 3:31 am
January 3, 2018 at 1:29 am
December 29, 2017 at 1:59 am
Good to know!
I would add a where clause to avoid empty stringDECLARE @A VARCHAR(6) = 'ABCDEF'
SELECT value FROM STRING_SPLIT(CAST(CAST(CAST(@A AS NVARCHAR) AS VARBINARY) AS VARCHAR),...
December 11, 2017 at 1:00 am
Viewing 15 posts - 106 through 120 (of 819 total)