2011 年 5月 17 日随笔档案 - Fanr_Zh

公告

2011年5月17日

摘要： USE AdventureWorks2008R2;GODECLARE complex_cursor CURSOR FOR SELECT a.BusinessEntityID FROM HumanResources.EmployeePayHistory AS a WHERE RateChangeDate <> (SELECT MAX(RateChangeDate) FROM HumanResources.EmployeePayHistory AS b WHERE a.BusinessEntityID = b.BusinessEntityID) ;OPEN complex_cursor 阅读全文

posted @ 2011-05-17 09:41 Fanr_Zh 阅读(310) 评论(0) 推荐(0)