The second option is useless, but it also is correct.

SELECT @p = N'@m varchar(200)="event message", @d datetime=getdate(), @u varchar(10)="Steve" '

I.e. this code returns 1 despite @p is initialized with 1234.

declare...

Great Steve! 100% wrong.

+1

😉

JSON is a big power!

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.