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,...

I think there's a typo:

CREATE SECURITY POLICY rls_CustomerFilter

ADD FILTER PREDICATE dbo.rls_customer_check(customerid)

ON dbo.CustomerAccessList;

GO

"customerid" instead of "username" passed as parameter to the inline function.

Anyway, the typo doesn't change the...

No, the ORDER BY in the SELECT...

Kaye Cahs (3/11/2016)

---

In my opinion, the sort results should be unpredictable because NULL is an unknown/unspecified value, which implies it cannot be sorted.

I'm not arguing that the answer is incorrect....

When execute below code then error message come, not * (star).

SELECT TRY_CONVERT(VARCHAR(1), 234523)

An error

Msg 195, Level 15, State 10, Line 1

'VARCHAR' is not a recognized built-in function name.

When execute below...

The strange thing is that this code returns NULL using NVARCHAR(1)

SELECT TRY_CONVERT(NVARCHAR(1), 234523)

Hugo Kornelis (2/18/2016)

---

The correct answer to this question is "it depends".

Now my question to you is if you can...