Find a SQL statement

恶魔右指

to:sting0626()
The following paragraph is to generate an incremental temporary table of 1-8000, through the temporary table to take the value of the column,
The second method above the same couple is the same charindex(',',a.name+',',b.id)
The b.id of this paragraph is the position where the value of',' is found from the first few digits.
SELECT TOP 8000 id = identity(int,1,1)
INTO # FROM syscolumns a, syscolumns b

ch1983912

select top 1000 id=identity(int,1,1) into #t from sysobjects,syscolumns

create table tableA(id int,gid varchar(8000))
insert tableA select 3456, '601988,600028,HK3988,HK0386'
insert tableA select 3457, '601988,600028'

go

select b.id,gid=substring(','+b.gid+',',a.id+1,charindex(',',','+b.gid+',',a.id+1)- a.id-1)
from #t a,tableA b
where substring(','+b.gid+',',a.id,1)=',' and len(b.gid)>a.id
order by a.id


drop table tablea,#T

/*result
id gid
---------------
3456 601988
3457 601988
3457 600028
3456 600028
3456 HK3988
3456 HK0386

*/

ch1983912

Build a temporary table #t used as a cross-connect table tableA and locate the position of ","

26710305

Learn! ~!
But my brother thought of another question!
Can it be the other way around?