利用SELECT语句生成删除语句

USE AdventureWorks2008R2  
GO
      
SELECT 'TRUNCATE TABLE ' + name 
FROM SYS.tables
WHERE name LIKE 'S%'
ORDER BY name DESC;
GO