Go to my github
摘要: 批量删除数据库表数据 备份--批量删除数据库表数据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 峡谷少爷 阅读(257) 评论(0) 推荐(0) 编辑