Viewing 15 posts - 301 through 315 (of 812 total)
ROWCOUNT_BIG() differs from @@rowcount only from the type.
So, ROWCOUNT_BIG() is the correct answer. All other functions may be followed by the OVER clause.
November 20, 2014 at 1:27 am
One solution may be this one:
use tempdb
execute (
'
use AnotherDB
declare @a as a
insert @a values(1),(2),(3)
exec z @a
')
or using sp_executesql.
November 19, 2014 at 1:17 am
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
Viewing 15 posts - 301 through 315 (of 812 total)