摘要： 1、遍历表某一列数据declare @au_id char( 11 )select @au_id = min( id ) from Awhile @au_id is not nullbegin select * from A where id = @au_idend2、分隔字符串create function str_split(@c varchar(2000),@split varchar(2))returns @t table(col varchar(20))asbeginwhile(charindex(@split,@c)<>0) begin insert @t(col) v 阅读全文