• Mike DiRenzo (3/10/2008)


    One forum poster said it worked for him in SSMS.

    Yes and it still does!...

    even with multiple parameters and ones delimited by single quotes

    create proc kev_test

    (

    @param1 varchar(50),

    @param2 varchar(50)

    )

    as set nocount on

    select 'the first parameter is ' + @param1 + ' the second is ' + @param2

    assign Ctrl-5 to kev_test

    new window..

    'first param','second param'

    highlight it, press Ctrl-5 and results are

    the first parameter is first param the second is second param