TimCarrett (6/6/2016)

---

As I haven't used In Memory tables yet I did a search on this I found the following:

https://blogs.technet.microsoft.com/dataplatforminsider/2016/01/06/json-in-sql-server-2016-part-2-of-4/

Which implies that ISJSON is available in SQL Server 2016 for In...

Good to know!

😀

Good question!

Thanks.

Ahahaha!:-D:-D:-D

Great!

😉

😎

Simple one!

😛

I will not be surprised if someone is able to get it wrong!

There is no limit to the jinx!

This question worths at least 7 points!!!!!

😀

Steve, the right event is "DROP TABLE" instead of "DELETE TABLE".

The correct answer works with numeric column, but it doesn't with other types.

+1

Good question!

I revised some features of temp tables.

Iulian -207023 (3/30/2016)

---

Nice question.

But why 2 on this assignment?

SELECT @SelectVariable = ID

FROM @Table

Since they were inserted in as 0,2,1 the last value would be expected to be 1, like...

Bob JH Cullen (3/17/2016)

---

I don't understand how this can work, even if you do pass 'bsmith' rather than 5 into the check function (can '5' be cast as a sysname,...