-->Features are avaliable in Sql Server 2012 DECLARE @X INT; SET @X=50; DECLARE @Y INT; SET @Y=60; Select iif(@X > @Y, 50, 60) As IIFResult DECLARE @ShowIndex INT; SET @ShowIndex =3; Select Choose(@ShowIndex, 'A','N','U','R','A','G','N','K') As ChooseResult
No comments:
Post a Comment