What can i use for a no-op in T-SQL? [duplicate]

Question

What's a good no-op in T-SQL? I want to use it as a place-holder in boilerplate code snippets. For example, if I'm stubbing out a query/UDF and have something like this:

IF @parm = 1
    BEGIN
    END
IF @parm = 2
    BEGIN
    END

I'll get the following error:

Incorrect syntax near the word 'END'

What could I throw in between there that would silence the compiler i.e. be executable?

Answer 1

As mentioned here you could declare a dummy variable. It shouldn't appear anywhere at all (execution plans, printed output etc):

IF @parm = 1
    BEGIN
        DECLARE @dummy1 bit
    END
IF @parm = 2
    BEGIN
        DECLARE @dummy2 bit
    END

Alternatively, you can use a label too:

IF @parm = 1
    BEGIN
        noop1:
    END
IF @parm = 2
    BEGIN
        noop2:
    END