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

That's easy!

But, try to answer this:

"What's the resut?"

SELECT TRY_CONVERT(VARCHAR(1), {D'2011-MAY-01'})

:-D:-D:-D

Extremely simple for C programmer!!!

Thanks

😀

Anyway -- the BOL quote explains it in technical implementation-related terms. The explanation given by Steve is the same but in more functional terms: the value is unknown, it could...

I disagree with explanation:

CHECK evaluates only true (accepted) or false (rejected) expression not UNKNOWN (accepted).

From BOL:

CHECK constraints reject...

Bellissimo!

😀

Useful question!

Thanks!