Truncate table if tailor made switch is off

--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

原文地址:https://www.cnblogs.com/JamesLi2015/p/2997944.html