Viewing 15 posts - 1,261 through 1,275 (of 3,348 total)
Ed Wagner (11/3/2015)
Stewart "Arturius" Campbell (11/3/2015)
Ed Wagner (11/3/2015)
edwardwill (11/3/2015)
One of the options is missing a checkboxYes. The third checkbox looks like it should be split into two separate checkboxes.
You'll...
November 3, 2015 at 7:38 am
Kim Crosser (11/2/2015)
Yes - it is a "kludge", but it works and is effective, and when used properly is safe.
I, too, think that NOLOCK certainly has its uses. You just...
November 2, 2015 at 2:58 pm
TomThomson (11/2/2015)
November 2, 2015 at 8:18 am
Pei Zhu-415513 (11/2/2015)
November 2, 2015 at 7:39 am
g.britton (11/2/2015)
November 2, 2015 at 7:33 am
Stewart "Arturius" Campbell (11/1/2015)
Good question, thanks HugoAnother side-effect: any records that are exclusively locked by another process may be skipped, thus returning an incomplete result set.
Thanks, Stewart!
Your remark is incorrect,...
November 1, 2015 at 9:41 am
I like the question. Good reminder of the intricacies of working with views.
There is a small mistake in the explanation, though. Changing data types will not cause conversion errors in...
October 30, 2015 at 7:33 am
freyes (10/28/2015)
I tink the question must include the collation, because if the collation is case sensitive the answer will be 2.
It would actually be 3 in a case sensitive collation....
October 28, 2015 at 7:12 am
wally 96967 (10/27/2015)
However nowhere does it say we start in Server2/Instance1
It doesn't, but that is not really relevant. When parsing the batch, SSMS will execute all the :connect commands in...
October 28, 2015 at 7:09 am
rmechaber (10/26/2015)
October 26, 2015 at 7:37 am
matthew.flower (10/26/2015)
I must be missing the explanation here?
The explanation tells you where the problem is, but not what it is.
[font="Courier New"]select '19.4615381' * -1.0;[/font] uses constant expressions, for which SQL...
October 26, 2015 at 6:42 am
Mark Fitzgerald-331224 (10/20/2015)
The CustomerId in the subqueries Select list and Order By has not been qualified with the table alias, so would give an...
October 21, 2015 at 2:52 pm
TomThomson (10/16/2015)
October 16, 2015 at 4:25 pm
SQL_kode_kracker (10/16/2015)
I get 3 rows returned when recreate the table in sql and run the query...
Can you script this and post the script here? Either (99% chance) you have a...
October 16, 2015 at 1:59 am
helenlu7 65408 (10/16/2015)
According to the txt you posted, mytext with myid =3 meets the predicate of the WHERE clause.
Yes. And the question reads how many rows are returned, not which...
October 16, 2015 at 1:58 am
Viewing 15 posts - 1,261 through 1,275 (of 3,348 total)