SQL Server 变量定义

  declare @id int
declare @name char(10) --注意：char（10）为10位，要是位数小了会让数据出错
set @id=1
set @name=‘sssss‘
select @id valu,@name nam

下面是我同事的一个情况， 要把一堆字符里面的表都给粘出来， 里面用到了变量的定义

declare @str varchar(max) =‘jgguf${wlsld2}  dhslsla${wlsld3}dhsl

sla${wlsld5}dh

dlsla${wlsgsld6} dlsla${wslsld7} dsgdlsla ‘

select value from string_split(replace(@str, ‘ ‘, ‘#‘), ‘$‘)

--{wlsld2}dhslsla

select substring(k.value2, 1, k.len1) as value3 from

(select substring(value, 2, charindex(‘}‘, value)) as value2,

              len(substring(value, 2, charindex(‘}‘, value))) - 2 as len1 from string_split(replace(@str, ‘ ‘, ‘#‘), ‘$‘)

) as k

where k.len1 > 0

go

SQL Server 变量定义

标签：charindex   declare   bsp   img   sub   varchar   code   arc   alt