xxxxxxxxxx
declare @SQL nvarchar(MAX) = ''
SELECT @SQL = @SQL + 'truncate table '+ t.TABLE_NAME + ';'
FROM sysindexes i
join INFORMATION_SCHEMA.TABLES t on t.TABLE_NAME = object_name(i.id)
WHERE t.TABLE_TYPE = 'BASE TABLE'
AND t.TABLE_NAME NOT IN ('Test')
GROUP BY t.TABLE_SCHEMA
, t.TABLE_NAME
HAVING MAX(i.rows) > 0
select @SQL
--exec sp_executesql @SQL