Naspinski.net

home about contact examples subscribe

loads of useful information, examples and tutorials pertaining to web development utilizing asp.net, c#, vb, css, xhtml, javascript, sql, xml, ajax and everything else...

<< Using a Custom Controller Class in Asp.Net MVC to Simplify Coding | Helper Methods for Validating Generated Linq-to-Entities edmx Files using Partial Classes >>

Ternary Operator in SQL

by naspinski 2/3/2012 1:32:00 PM

there technically isn't one, but an equivalent isn't too hard to do

This ternary in C#:

(str.Length > 0 ? "yes" : "no");

Is equivalent to this in SQL:

(CASE WHEN LEN(@str) > 0 THEN "yes" ELSE "no" END);

Tags: sql

Related posts

An error occured: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.One simple solution to this error I often faceRunning C# libraries with the SQL CLRYou can run your dlls from inside SQL - but it is a bit limitedTernary operators simplifiedMaking sense of mysterious ternary operator

Comments are closed