Get rid of Case Queries:
Now we have new way to get rid of lengthy case SQL. In SQL 11.0 (Formally Name: SQL 2012) we can use IIF (if and only if) instead of Case. IIF is newly introduce in SQL 11, however it was already there with VB 4.0.
Now we have new way to get rid of lengthy case SQL. In SQL 11.0 (Formally Name: SQL 2012) we can use IIF (if and only if) instead of Case. IIF is newly introduce in SQL 11, however it was already there with VB 4.0.
So persons who have worked with any version of VB/ VB.Net, they are already aware about this function.
No comments:
Post a Comment