创建的存储过程存放在数据库-->可编程性如右图：

例子：

CREATE PROCEDURE sp_DeleteAllData

AS

BEGIN

    EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'

    EXEC sp_MSForEachTable 'ALTER TABLE ? DISABLE TRIGGER ALL'

    EXEC sp_MSForEachTable 'DELETE FROM ?'

    EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'

    EXEC sp_MSForEachTable 'ALTER TABLE ? ENABLE TRIGGER ALL'

    EXEC sp_MSFOREACHTABLE 'SELECT * FROM ?'

END

--删除

USE YourDatabaseName; -- 替换为实际的数据库名

GO

DROP PROCEDURE YourSchema.YourStoredProcedure;