Viewing 15 posts - 106 through 120 (of 821 total)
This applies only to uniqueidentifier. For variables of type char, varchar, etc. not.
I created the table 'aaa' in tempdb which has a binary collation.
I created a db...
April 5, 2018 at 2:39 am
March 27, 2018 at 2:06 am
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
Viewing 15 posts - 106 through 120 (of 821 total)