摘要: 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,@ 阅读全文
posted @ 2012-04-23 19:28 aiaito 阅读(370) 评论(0) 推荐(0) 编辑