Quickly delete Umbraco nodes by document type in SQL
Ever needed to delete all nodes by a document type or delete all nodes from the recycle bin in Umbraco? This little script should help.
Delete Umbraco nodes by Document Type Alias
BEGIN TRAN
DECLARE @Nodes TABLE (NodeId int)
INSERT INTO @Nodes (NodeId)
SELECT top 1000 n.id
FROM cmsContent