Sql 清空数据库表的数据语句

 Select Name FROM [Fyd.Decoration.DB].. SysObjects  Where XType='U' AND NAME NOT IN('DNETArea','DNETMaterial','DNETSystemVariable','DNETTag','DNETTagGroup')
 
 USE [Fyd.User.DB]
declare @s nvarchar(max)
select @s=ISNULL(@s+';','')+'truncate table '+name from [Fyd.User.DB].. sysobjects where XType='U' AND
NAME NOT IN('DNETGradeGroup','DNETGroup','DNETRole')
exec (@s)
GO

 

 USE [Fyd.Decoration.DB]
declare @s nvarchar(max)
select @s=ISNULL(@s+';','')+'truncate table '+name from [Fyd.Decoration.DB].. sysobjects where XType='U' AND
NAME NOT IN('DNETArea','DNETMaterial','DNETSystemVariable','DNETTag','DNETTagGroup')
exec (@s)
GO

 USE [Fyd.Statistic.DB]
declare @s nvarchar(max)
select @s=ISNULL(@s+';','')+'truncate table '+name from [Fyd.Statistic.DB].. sysobjects where XType='U' AND
NAME NOT IN('DNETGradeGroup','DNETGroup','DNETRole')
exec (@s)
GO
 

USE [Fyd.Attachment.DB]
TRUNCATE TABLE DNETAttachment
GO

转载于:https://www.cnblogs.com/tiwlin/archive/2010/08/04/1791697.html