求一段T-SQL语句实现多个整数转char(n)类型字段的数据

begindeclare @a1 int,@a2 int,@a3 int,@a4 intdeclare @result char(8)set @a1=1+cast(rand()*33 as int) ---1-33随机数set @a2=1+cast(rand()*33 as int) ---1-33随机数set @a3=1+cast(rand()*33 as int) ---1-33随机数set @a4=1+cast(rand()*33 as int) ---1-33随机数select @result=replicate('0',2-len(cast(@a1 as varchar(2))))+cast(@a1 as varchar(2))+replicate('0',2-len(cast(@a2 as varchar(2))))+cast(@a2 as varchar(2))+replicate('0',2-len(cast(@a3 as varchar(2))))+cast(@a3 as varchar(2))+replicate('0',2-len(cast(@a4 as varchar(2))))+cast(@a4 as varchar(2)) ---1-33随机数转换为字符型再连接(若随机数为个位,则前补'0')赋值给@resultprint '@result is ' +@result -----输出@resultinsert into tb_num46(字段1,字段2,...,num4)values(字段1内容,字段2内容,...,@result) ----将@result结果插入end 收起