sql技巧

backup database rawz_ol to disk='e:\rawz_ol.bak'--备份数据库
select 'truncate table ' + name +'; -- select * from '+ name from sysobjects where xtype ='u'--删除所有表