A complete guide to people who wants to learn .Net Technology with Basics and Advance level
Wednesday, April 18, 2012
How to Write Case Statement in SQL
Select StudentId,
case
when StudentExpiryDate<getdate() then
StudentName + ' [Expired]'
else
StudentName
end
StudentName from ms_survey_corporate where StudentId=2000
No comments:
Post a Comment