数据库游标复习(MSSQL用内置的pubs做纯SQL的报表)

今天复习了下游标 流程控制语句 SQL查询等基础语法 做了一个纯SQL报表 附图：

?代码如下：用了一个游标的嵌套呵呵

declare @jobid smallint ,@jobdesc varchar(50)declare @name varchar(50),@joblvl smallint ,@hdate smalldatetimedeclare cur_job cursor for  select job_id,job_desc from jobs order by job_id ascopen cur_jobfetch next from cur_job into @jobid,@jobdescwhile @@fetch_status=0begin  --显示当前的工作编号和工作描述 print cast(@jobid as varchar(4))+';'+@jobdesc declare cur_emp cursor for   select fname +' '+lname,job_lvl,hire_date     from employee   where job_id=@jobidopen cur_emp fetch next from cur_emp into @name ,@joblvl,@hdate while @@fetch_status=0   begin print '雇员:'+@name +',级别：'+cast(@joblvl as varchar(4))+',参加工作日期：'+datename(year,@hdate)+'年'+        datename(mm,@hdate)+'月'+datename(day,@hdate)+'日'        fetch next from cur_emp into @name ,@joblvl,@hdate   end  print'================================================================================='  close cur_emp  deallocate cur_emp  fetch next from cur_job into @jobid,@jobdescendclose cur_jobdeallocate cur_jobgo