Log Shipping – NORECOVERY vs. STANDBY mode

set
nocount
on

declare @Tab table ( id int
identity
, i int
,j date
)

insert
into @Tab select 1,
'2008-01-01'

insert
into @Tab select 1,
'2008-01-02'

insert
into @Tab select 1,
'2008-01-03'

insert
into @Tab select 2,
'2008-01-04'

insert
into @Tab select 2,
'2008-01-15'

insert
into @Tab select 1,
'2008-01-21'

 

declare @res varchar(max)

 

update @Tab

set @res =
COALESCE(@res+',',
'')+CAST(id as
varchar
),

j =
SYSDATETIME()

where i = 1

 

select
*
from @Tab

select @res