SQL 将一串字符串转换为列插入临时表

将一串字符串转换为列插入临时表

declare @keywordHotID varchar(8000)

set @keywordHotID='1,2,3'

set @sql='insert into #tempKeyWordLink(KeyWordHotID) select '+replace(@KeyWordHotID,',',' KeyWordHotID union all select ')

    exec(@sql)