Viewing 15 posts - 316 through 330 (of 825 total)
Koen Verbeeck (10/29/2014)
Louis Hillebrand (10/29/2014)
Koen Verbeeck (10/29/2014)
Nice question, thanks.A bit curious as why you use DATALENGTH instead of just LEN.
With DATALENGTH you can also use a space as the separator,...
October 29, 2014 at 2:47 am
Koen Verbeeck (10/21/2014)
Very excellent question.Thanks Sean.
+1
October 21, 2014 at 12:54 am
happycat59 (10/14/2014)
Msg 156, Level 15, State 1, Procedure my_sp, Line 2
Incorrect syntax near the keyword 'FROM'.
because "Column" is a reserved keyword and needs to be delimited if you...
October 15, 2014 at 1:11 am
rabih_karam (9/30/2014)
DATABASE Name : Master
-----------------------------
0.713591993212924
0.713591993212924
0.713591993212924
0.713647892126698
0.713647892126698
0.713647892126698
0.713647892126698
0.713722424011731
0.713722424011731
0.713722424011731
0.713722424011731
0.713722424011731
0.713722424011731
0.713722424011731
0.713852854810538
0.713871487781797
0.713871487781797
0.713908753724313
0.713908753724313
0.713908753724313
and if i run it on other DB I ll get the below result
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713852854810538
0.713852854810538
0.713852854810538
0.713852854810538
0.713852854810538
0.713852854810538
so in...
September 30, 2014 at 1:10 am
Triggers on tables execute only if at least ONE row is affected. So, explanation is wrong.
September 23, 2014 at 1:59 am
From BOL:
MERGE
[ TOP ( expression ) [ PERCENT ] ]
[ INTO ] <target_table> [ WITH ( <merge_hint> ) ] [...
September 9, 2014 at 12:58 am
Eirikur Eiriksson (9/7/2014)
...but it works for Joe in HR (that's his default schema);-)😎
That's true!
September 8, 2014 at 1:06 am
pmadhavapeddi22 (9/4/2014)
When I work with CTE, I get this error when I dont give smicolon, so it was easy to answer 🙂Thanks for the question
+1
September 4, 2014 at 1:14 am
What do you mean with "we can use print and exec commands in single query"?
August 27, 2014 at 2:19 am
I don't like qotd too long.
But, BOL states that with SERIALIZABLE isolation level:
Other transactions cannot insert new rows with key values that would fall in the range of keys read...
August 14, 2014 at 12:47 am
Viewing 15 posts - 316 through 330 (of 825 total)