存储过程中拆分传入的字符串,并插入到表中

 自个新写的一段SQL代码,用在存储过程中,用来拆分传入的字符串,并插入到表中:

不知道效率高不高?(高手请指点一下)

declare @sql nvarchar(4000)
  set @sql = Replace(@Vote,'|',' union all select ')
  set @sql = 'select ' + @sql
  set @sql = Replace(@sql,'select ','select '+cast(@Topic_ID as nvarchar(20))+','+cast(@VoteType as nvarchar(2))+','''+Convert(nvarchar(10),DateAdd(d,@OutTime,getdate()),120)+''',')
  set @sql = 'insert Forum_Vote(Topic_ID,VoteType,TimeOut,Vote) '+@sql
  exec (@sql)