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

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

You could throw a print in there:

IF @parm = 1
    BEGIN
    print 'need to implement 1'
    END
IF @parm = 2
    BEGIN
    print 'need to implement 2'
    END

You could also try...

WAITFOR DELAY '0:0';

Related