• I use comments to test changes to parameterised stored procedures without having to create or alter the sproc first.

    /**/

    CREATE PROC Test @param1 INT, @param2 VARCHAR(20) AS

    --*/DECLARE @param1 INT/*

    --*/DECLARE @param2 VARCHAR(20)/*

    --*/

    SELECT @param1, @param2

    By breaking the close comment in the initial /**/ you coment out the CREATE (or ALTER) statement and uncomment the DECLARE statements.

    /**-/

    CREATE PROC Test @param1 INT, @param2 VARCHAR(20) AS

    --*/DECLARE @param1 INT/*

    --*/DECLARE @param2 VARCHAR(20)/*

    --*/

    SELECT @param1, @param2