• Create Procedure [procedureName]

    As

    -- your query goes here

    GO -- end of procedure

    Neeraj Prasad Sharma
    Sql Server Tutorials