USE AdventureWorks2008R2
GO
SELECT 'TRUNCATE TABLE ' + name
FROM SYS.tables
WHERE name LIKE 'S%'
ORDER BY name DESC;
GO
利用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