摘要:
批量删除数据库表数据 备份--批量删除数据库表数据declare@tbnamevarchar(250)declare#tbcursorforselectnamefromsysobjectswhereobjectproperty(id,'IsUserTable')=1open#tbfetchnextfrom#tbinto@tbnamewhile@@fetch_status=0beginexec('delete['+@tbname+']')fetchnextfrom#tbinto@tbnameendclose#tbdeallocate#tb 阅读全文
posted @ 2011-11-17 09:05
峡谷少爷
阅读(266)
评论(0)
推荐(0)

浙公网安备 33010602011771号