?? Operator and it’s use case(jachman.wordpress.com)

submitted by Jachman(530) 4 years, 3 months ago

Long time I asked myself, for what the heck I could use the ?? operator. Last days I found the perfect scenario for using this operator. read more...

2 comments |category: C# |Views: 4

tags: notagain C# operator .Net another

Conditional WHERE clauses in T-SQL using comparison operators(dotnetzone.gr)

submitted by sotirisf(315) 5 years, 1 month ago

Ever had a query where you wished you could be able to specify the operator (equal, not equal, greater than, etc.) for each column contained in your WHERE clause, without having to use ugly string concatenations and the infamous EXEC keyword? Here we'll see an example of how this can be achieved with the use of a plain SQL query together with some CASE statements. read more...

add a comment |category: Database |Views: 659

tags: comparison operator where SQL Server another