I use this feature a lot, see the following example:

declare @t table (i int identity primary key, name sysname)
declare @i int = 1
,@name sysname

insert into @t
select TOP(10)...

I get it right, but I admit that the question is a little confusing: the value of 4 is the 3rd bit (starting from position ZERO, 2 is the right...

I think that ROLLBACK doesn't return any message.

In my browsers (edge & firefox)

In the explanation, to be precise, I would change "where the first number is not a 9"

with "where the first char is not a 9"

Good catch!

It is Interesting that NULL never has a BaseType, also if you cast it to a defined type (e.g. INT).

SELECT *
,LEN(V.a)
,dataLENgth(V.a)
,SQL_VARIANT_PROPERTY(V.a, 'BaseType')
 FROM (VALUES
 (N'1')
,('2')
,('3')
,(NULL)
) AS...

Try this (adjust for your needs), then execute the output script:

set nocount on
select DISTINCT 'exec sp_helptext ' AS '--','[' + o.name + ']' AS [ ],CASE OBJECTPROPERTY(o.id,'ExecIsTriggerDisabled')...

What's the syntax for "LOAD CERTIFICATE"? I cannot find it on BOL.

I saw that CREATE CERTIFICATE or ALTER CERTIFICATE loads the certificate from a file.

*** sorry for the spoilers; but my comment didn't make sense to me without them ***

I debated with myself between "Zero records" and the more comprehensive "Returns distinct rows...

The question is about the...

Of course the isolation level of the database should be as in the image

If the query returns no row, it means that there are not uncommitted data (inserted or modified).

• This reply was modified 2 years, 6 months ago by  Carlo Romagnano.

For debug, I used this query to return all rows inserted or changed in all open transaction.

How to reproduce the scenario:

Start a transaction in one session, insert or modify data...

If you assume that the string always starts with '\1\' (as the original post) and you do not know then length of text then you can use STUFF instead of...

WITH ctePC
AS ( SELECT expression
     FROM
       ( VALUES
         ...