摘要:
删除表:DECLARE@TableNVARCHAR(30)DECLAREtmpCurCURSORFORSELECTnameFROMsys.objectsWHERETYPE='U'ANDnameLIKEN'HSUPA%'OPENtmpCurFETCHNEXTFROMtmpCurINTO@TableWHILE@@FETCH_STATUS=0BEGINDECLARE@sqlVARCHAR(100)SELECT@sql='droptable'+@TableEXEC(@sql)FETCHNEXTFROMtmpCurINTO@TableENDCLOSEtmp 阅读全文