"Prodded"????

My first thought on reading this was "oh, dear, Steve just shot a pork chop at Jeff Moden"! 😀

Rich

sknox (9/9/2016)

---

Good question, but the explanation is incomplete. Precision is only half of the story, the other being scale.

1.0 can fit in a number with precision of 1, if the...

About BI tools:

I've run SSRS and been working 6 months with Tableau. They are (and are intended to be) very different products. Tableau wins hands down for interactive...

Careful with that cursor definition: I had a horrible issue with backups never being executed using a solution much like this. Although a query from sys.databases returned the correct...

TomThomson (4/6/2016)

---

Ed Wagner (4/6/2016)

---

TomThomson (4/6/2016)

---

It was however easy to see which of them was the one that was wanted, just by looking at the wording - it was the only...

Hugo Kornelis (4/7/2016)

---

Nor should you. In production code, I would always write out the explicit intent instead...

Funny, I've had the reverse problem migrating to using Toad for Oracle: where is everything I know in SSMS? Chacun a son gout, as they say. 🙂

Here's an...

Scratched my head a bit at that first ORDER BY (on the INSERT). Was that just smoke to trip us up?

🙂

Rich

Nice article Hugo, and I like your inclusion of execution plans to show how untrusted foreign keys can affect query plans.

A nice, small thing you did that will probably help...

--Which FK constraints aren't trusted? (e.g.,...

Maybe everyone following this already knew it, but as I don't use CONVERT much at all, I had to read through the BOL entry Steve linked to for CONVERT. ...

Thanks for the speculation, Hugo.

Huh. I guess in this case, the "N" in NVARCHAR must stand for "NULL"? Or maybe "Not gonna return an asterisk if the conversion...

Echoing what others have said: back up the database and restore it elsewhere. You should be doing that regularly, whether or not you need to extract data for reporting...

Great question, Steve, thank you for exposing this. Anyone else find BOL more than less than unhelpful here?

Return Types

Returns a value cast to the specified data type...

I think in this case you weren't hijacking at all (I believe you said you arrived here via Google for a similar issue), and I've appreciated the additional testing and...