SQL开发笔记

存储教程添加游标：

declare @Cur Cursorset @Cur =cursor scroll for select ID from T_CompanyJobs where Status <> 3open @Curfetch first from @Cur into @IDwhile @@fetch_status = 0beginselect @DateTime = DateTime from T_CompanyJobs where ID = @IDif(dateadd(day,60,@DateTime)<GetDate())beginupdate T_CompanyJobs set Status = 3where ID = @IDendendclose @Cur

 

While语句

while (not (@ParentID is null)) and (@ParentID > -1)beginselect @ParentID = ParentID, @ParentName = [Name] from T_Site_VideoTypes where [ID] = @ParentIDset @Result = @ParentName + '/' + @Resultend