Shulou(Shulou.com)06/01 Report--

Create table curtest (djbh varchar (20) primary key,sales varchar (20)) goinsert curtestselect 'A1 recording, 01LJ 02j03' union all-create a table and insert a record of select 'A2WH 02' union allselect' A3JI 02' union allselect 'A4' Godeclare cur_test cursor for select * from curtest-declare cursor declare @ djbh varchar (20)-define variable document number declare @ sales varchar (20)-define variable sales declare @ star int,@len int,@dhwz int-define variable start, length Comma position open cur_test-- Open the cursor fetch next from cur_test into @ djbh,@sales-- get the first record while (@ @ FETCH_STATUS=0)-- confirm the execution result based on the returned status. 0 means successful beginset @ star=1-assign 1set @ dhwz=CHARINDEX (',', @ sales,@star) to the start position-get the first comma position set @ len=LEN (@ sales)-get the field length while (@ star)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.