BEGIN DECLARE @t TABLE(ID int IDENTITY, ch_apno Varchar(50)) DECLARE @result varchar(100),@flag int, @temp Varchar(20) SET @result = '' SET @temp = '' INSERT INTO @t(ch_apno) SELECT ch_apno FROM iech00d1 WHERE ch_no = @ch_no AND ch_seq = @ch_seq SELECT @flag= (SELECT TOP 1 ID FROM @t ORDER BY ID DESC) IF @flag IS NOT NULL BEGIN WHILE(@flag > 0) BEGIN SET @temp = (SELECT ch_apno FROM @t WHERE ID = @flag) IF(CHARINDEX(@temp,@re
因变量的概念,Table 变量的用法
BEGIN DECLARE @t TABLE(ID int IDENTITY, ch_apno Varchar(50)) DECLARE @result varchar(100),@flag int, @temp Varchar(20) SET @result = '' SET @temp = '' INSERT INTO @t(ch_apno) SELECT ch_apno FROM iech00d1 WHERE ch_no = @ch_no AND ch_seq = @ch_seq SELECT @flag= (SELECT TOP 1 ID FROM @t ORDER BY ID DESC) IF @flag IS NOT NULL BEGIN WHILE(@flag > 0) BEGIN SET @temp = (SELECT ch_apno FROM @t WHERE ID = @flag) IF(CHARINDEX(@temp,@re
最新评论