麻烦解释一下代码

来源:百度知道 编辑:UC知道 时间:2024/05/14 03:37:04
insert into @tab values('2007-01-02','0018')
insert into @tab values('2007-01-04','0018')
insert into @tab values( '2007-01-08','0018')
insert into @tab values( '2007-01-09','0018')
insert into @tab values( '2007-01-10','0018')
insert into @tab values( '2007-01-11','0018')
insert into @tab values( '2007-01-13','0018')
insert into @tab values( '2007-01-14','0018')
insert into @tab values( '2007-01-15','0018')
insert into @tab values('2007-01-17','0018')
insert into @tab values( '2007-01-18','0018')
insert into @tab values( '2007-01-20','0018')
insert into @tab values( '2007-01-21','0018')
insert into @tab values( '2007-01-22','0018')
insert into @tab values( '2007-01-23','

明显的一个procedure。
对游标的理解不是很深刻,可能会有错误,见谅。

create procedure @tab varchar(20)
as

insert into @tab values('2007-01-02','0018') //往表@tab中插入数据。
insert into @tab values('2007-01-04','0018')
insert into @tab values( '2007-01-08','0018')
insert into @tab values( '2007-01-09','0018')
insert into @tab values( '2007-01-10','0018')
insert into @tab values( '2007-01-11','0018')
insert into @tab values( '2007-01-13','0018')
insert into @tab values( '2007-01-14','0018')
insert into @tab values( '2007-01-15','0018')
insert into @tab values('2007-01-17','0018')
insert into @tab values( '2007-01-18','0018')
insert into @tab values( '2007-01-20','0018')
insert into @tab values( '2007-01-21','0018')