In SSMS, set the result mode to text (Press Control+T) , run the following query and see the result
set nocount on
space(17-len(replicate(char(37),case when no>3 then no-3 else no end)))
replicate(char(37),case when no>3 then no-3 else no end*2-1)
select top 8 row_number() over (order by name) as no from sysobjects
select space(10)+cast(0x4861707079204E65772059656172 as varchar(100))
I am rajakulai, am new to this blog. I have a requirement on sql server service broker. Can you please share any sample to work with sql server service broker.
And happy new year to you as well.
This comment is waiting for moderation.