create schema PIKA
create schema CHOU
GO
 
create procedure PIKA.BBB as select 111
create procedure CHOU.BBB as select 222
create procedure BBB as select 333
GO
 
exec CHOU.BBB
exec PIKA.BBB
exec BBB

create table uni (n int primary key)
go
create procedure InsUni @k int
as
  begin try
    insert into uni select @k
    print 'Inserted !!!'
  end try
  begin catch 
    print 'Failed !!!'
  end catch
go
exec InsUni 7
--Inserted !!!
exec InsUni 7
--Failed !!!

CREATE DATABASE WO1 ON ( NAME = 'MyDb_Data', FILENAME = 'C:DATAWO1.SS') AS SNAPSHOT OF MyDB
GO
select * from WO1..Docs
GO

CREATE TRIGGER safety 
ON DATABASE 
FOR CREATE_TABLE 
AS 
   PRINT 'CREATE TABLE Issued.'
   PRINT CONVERT (nvarchar (1000), EVENTDATA() )
GO

select SPACESTRING,[10],[20],[30],[40],[50] from TABLE_CDC as x 
  PIVOT(count(x.IDCDC) for x.IDSTATUS in ([10],[20],[30],[40],[50])) as X

SELECT XMLSIGNATURE,SIGNEDDOCUMENT into SIG_1 FROM SIGNATURE 
SELECT convert(XML,XMLSIGNATURE) as XMLSIGNATURE,convert(XML,SIGNEDDOCUMENT) as SIGNEDDOCUMENT 
  into SIG_2 FROM SIGNATURE 

-- Увы так не получится. Надо использовать функцию
alter table SIGNATURE add LegalName as convert(XML,XMLSIGNATURE).query('data(//LegalName)')
GO
 
-- Создаем функцию
create function LegalName (@t TEXT) 
  returns varchar(128) -- не varchar(max) 
  with schemabinding  -- !!!
as 
  begin 
  return convert(varchar(max),convert(XML,@t).query('data(//LegalName)')) 
  end
GO
 
-- создаем колонку
alter table SIGNATURE add LegalName as dbo.LegalName(XMLSIGNATURE)
GO
 
-- и индекс
create index IX_LegalName on SIGNATURE (LegalName)
 
-- проверка что работает
select * from SIGNATURE where LegalName='Test Benoit Signature 2'
GO

create table SIG_3 (n int identity primary key, doc xml)
-- в таблице дожен быть PK
 
-- заполняю таблицу
insert into SIG_3 (doc) 
  select SIGNEDDOCUMENT from SIG_2 
    where SIGNEDDOCUMENT is not null

select count(*) from SIG_3 where 
  doc.exist('//cdcInfo[title="test steph"]')=1
à 2 lignes
CPU time = 1109 ms,  elapsed time = 1105 ms.

create primary XML index XXX on SIG_3 (doc)
 
select count(*) from SIG_3 where 
  doc.exist('//cdcInfo[title="test steph"]')=1
à 2 lignes
CPU time = 265 ms,  elapsed time = 287 ms.

create XML index ZZZ on SIG_3 (doc) using xml index XXX for path
 
select count(*) from SIG_3 where 
  doc.exist('//cdcInfo[title="test steph"]')=1
à 2 lignes
CPU time = 47 ms,  elapsed time = 29 ms.

select count(*) from SIG_3 where 
  doc.exist('//cdcInfo[title="TEST STEPH"]')=1
à 2 строки

select count(*) from SIG_3 where 
  doc.exist('//cdcInfo[TITLE="TEST STEPH"]')=1
à 0 строк

declare @val varchar(max)
set @val='test steph'
select count(*) from SIG_3 where   
  doc.exist('//cdcInfo[title=sql:variable("@val")]')=1
à 2 строки

select * from (
  select row_number() over (order by Name desc) RNUM,
    * from Docs
  ) X where X.RNUM>=1000 and X.RNUM<1010
order by Name desc