/* ------sqlserver 2008 删除某数据库所有表-------- */
declare @tname varchar(8000)
set @tname=''
select @tname=@tname + '[' + Name + '],' from sysobjects where xtype='U'
select @tname='drop table ' + left(@tname,len(@tname)-1)
exec(@tname)
删除 Email的全部数据
delete Email
删除 Email下 id为的数据
delete Email
where Emailid='1'
删除全部
truncate table GroupInfo -- 不会产生log