摘要:
begincreatetable#table(theIDintidentity(1,1),PriceNamevarchar(1000),theDatedatetime,Pricesvarchar(1000),theCTIDsvarchar(500))declare@MyDatedatetimeDECLAREmycursorCURSORFOR--创建一个游标selectdistinctTicketDatefromConceTablewhereTicketID=5OPENmycursorFETCHNEXTFROMmycursorINTO@MyDateWHILE@@FETCH_STATUS=0BEG 阅读全文