sql server 循环清除表数据

DECLARE @sqlTabName varchar(100);
-- 声明游标
DECLARE C_Employees CURSOR FAST_FORWARD FOR
   SELECT TableName FROM BdItem --表名配置表
OPEN C_Employees;

-- 取第一条记录
FETCH NEXT FROM C_Employees INTO @sqlTabName
WHILE @@FETCH_STATUS=0
BEGIN
        
   EXEC('TRUNCATE TABLE '+@sqlTabName)
   print @sqlTabName;
    -- 取下一条记录
    FETCH NEXT FROM C_Employees INTO @sqlTabName
END

-- 关闭游标
CLOSE C_Employees;

-- 释放游标
DEALLOCATE C_Employees;