USE AdventureWorks2008R2
GO
SELECT 'TRUNCATE TABLE ' + name
FROM SYS.tables
WHERE name LIKE 'S%'
ORDER BY name DESC;
GO
[SQL Server] 利用SELECT语句生成表数据删除语句
最新推荐文章于 2022-12-06 19:06:17 发布
USE AdventureWorks2008R2
GO
SELECT 'TRUNCATE TABLE ' + name
FROM SYS.tables
WHERE name LIKE 'S%'
ORDER BY name DESC;
GO