摘要：
删除表：DECLARE@TableNVARCHAR(30)DECLAREtmpCurCURSORFORSELECTnameFROMsys.objectsWHERETYPE='U'ANDnameLIKEN'HSUPA%'OPENtmpCurFETCHNEXTFROMtmpCurINTO@TableWHILE@@FETCH_STATUS=0BEGINDECLARE@sqlVARCHAR(100)SELECT@sql='droptable'+@TableEXEC(@sql)FETCHNEXTFROMtmpCurINTO@TableENDCLOSEtmp 阅读全文
posted @ 2013-07-19 14:25
小李弯刀
阅读(280)
评论(0)
推荐(0)
浙公网安备 33010602011771号