根据存储过程中其他操作的结果在存储过程中执行操作?

declare @myVarChar varchar(1);

Select @myVarChar=MyCol From MyTable Where MyOtherCol = @myKey;

If @myVarChar = 'A'
Begin
End

这就是你要找的吗?

IF @variable = 'foo'
    BEGIN
    <do some stuff>...
    END
IF @variable = 'boo'
    BEGIN
    <do some other stuff>...
    END
IF @variable = 'neither foo nor boo'
    BEGIN
    <do whatever you want as a failsafe>
    END