Is it possible to use a case statement to then execute a procedure?

[sonname]

For example something like

SELECT CASE @type
WHEN 25 THEN exec proc
END
Or is there something similar like this. I hate to write if statements to do this.

 

[amrita418]

No. Use If/Else block to do something like this.

Declare 
     @type Int
     Set @type = 27
     If @type = 25
           Exec sp_help YourTable
     Else 
	   Print 'Value for Type is ' + Convert(Varchar(5), @type)

Regards,
AA