Truncate table if tailor made switch is off

weixin_30687811

于 2013-04-03 14:56:00 发布

阅读量69

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/JamesLi2015/archive/2013/04/03/2997944.html

本文提供了一个SQL脚本，用于批量删除指定数据库中的特定表数据，适用于数据库管理场景。

--Function Code : PRSFRT/SQPRSFR
--PRMRTHT MaterialReservationTransferDetailTempEntity
--PRMRTD MaterialReservationTransferDetailEntity
--PRMRTH MaterialReservationTransferEntity
Declare @DB_DATABASE Nvarchar(128)
Declare @Sql Nvarchar(400)

DECLARE @TAILOR_HEILEI BIT
SELECT @TAILOR_HEILEI=TAILOR_HEILEI FROM dbo.ADPARM
IF @TAILOR_HEILEI=0
BEGIN

Declare Cur Cursor For Select DB_DATABASE From dbo.ADCOMP WHERE SUSPENDED='N'
Open Cur
Fetch next From Cur Into @DB_DATABASE

While @@fetch_status=0
BEGIN
    SELECT @Sql=''
    SELECT @Sql='DELETE '+@DB_DATABASE +'.dbo.PRMRTD'
    EXECUTE (@Sql)

    SELECT @Sql=''
    SELECT @Sql='DELETE '+@DB_DATABASE +'.dbo.PRMRTH'
    EXECUTE (@Sql)

    SELECT @Sql=''
    SELECT @Sql='DELETE '+@DB_DATABASE+'.dbo.PRMRTHT'
    EXECUTE (@Sql)

    Fetch next From Cur Into @DB_DATABASE
End
Close Cur
Deallocate Cur
END