<< How To Pass A DataTable To A Stored Procedure Using C# and SQL Server | How To Update From Using T-SQL >>

How To Use a CASE Statement In T-SQL

0Comments

TODO:

Have you ever wanted to use a CASE statement in your T-SQL Select Query?

SOLUTION:

SELECT   Column = 
      CASE 
         WHEN SomeValue =  0 THEN 'Zero'
         WHEN SomeValue < 0 THEN 'Minus'
         ELSE 'Plus'
      END
FROM MyTable

NOTES:

There are no notes on this topic.

How To Use A CASE Statement In A Select In T-SQL (SQL Server)TODO: Have you ever wanted to use a CASE statement in a SELECT statement in T-SQL? SOLUTIO...How To Create A Table From a Select Statement Using T-Sql In SQL ServerTODO: Have you ever wanted to create a table from a SELECT statement in SQL Server? SOLUTI...How To Convert A Variable To Lower Case In JQueryTODO: Have you ever wanted to check a var against a string and ensure case is not an issue? ...

	Subscribe		Contact
Archive		Twitter

How To Use a CASE Statement In T-SQL

Related posts

Add comment

RecentPosts

How To Use a CASE Statement In T-SQL

Related posts

Add comment

RecentPosts

Categories

Newsletter

Thank you