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!

I disagree with explanation, the error generated

Msg 4104, Level 16, State 1, Line 2

The multi-part identifier "o.object_id" could not be bound.

it's not caused by CROSS APPLY, but a reference...

I think they started earlier with stored procs ('90): sql 6.0

The "order by" clause misses!

Try this:

declare @image as table (

row_id tinyint

primary key clustered (row_id desc)

);

insert into @image(row_id)

values(1),(2),(3),(4),(5),(6),(7),(8),(9)

select

case

when max(i.row_id) over() - i.row_id >...