摘要：ALTER PROCEDURE dbo.dingpiaoinsert(@userId uniqueidentifier,@Str nvarchar(200),@movie_yingtingid int,@date datetime)ASbegin begin try DECLARE @Index int; DECLARE @Left nvarchar(50); WHILE CHARINDEX('|',@Str) > 0 BEGIN SELECT @Index = CHARINDEX('|',@Str); SELECT @Left = LEFT(@Str,@ 阅读全文