USE AdventureWorks2008R2
GO
SELECT 'TRUNCATE TABLE ' + name
FROM SYS.tables
WHERE name LIKE 'S%'
ORDER BY name DESC;
GO
[SQL Server] 利用SELECT语句生成表数据删除语句
USE AdventureWorks2008R2
GO
SELECT 'TRUNCATE TABLE ' + name
FROM SYS.tables
WHERE name LIKE 'S%'
ORDER BY name DESC;
GO
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
