How to Compare two strings using a if in a stored procedure in sql server 2008?

Posted by VJ on Stack Overflow See other posts from Stack Overflow or by VJ
Published on 2010-05-20T20:29:39Z Indexed on 2010/05/20 20:30 UTC
Read the original article Hit count: 165

declare @temp as varchar
  set @temp='Measure'
  if(@temp == 'Measure')
Select Measure from Measuretable
else
Select OtherMeasure from Measuretable

© Stack Overflow or respective owner