Many of them are interchangeable with various tables. The CASEs in this blog are some commonly requested types of CASE Statements in the Forum. And you use END to let the SQL know you are finished with your IF/THEN lines. You must tell SQL first that you are about to do the IF/THEN by using the word “CASE”. What a CASE does is group together statements of “IF something is this THEN do this” (display a name, term, perform a calculation, display a value, etc.). The concept can not only provide better descriptions, it can provide accurate values, handle exceptions correctly, can perform the correct calculation, and can also act as a filter when End Users (or yourself) are “slicing and dicing” the SQL results. Instead of having an “O” under a DocStatus column, you can display the word of “Open”. The CASE function in SQL is a great way to customize the output of your SQL to better suit the needs of your End Users. She has a great start, but we are going to get her up to the next level, and one way is going to be the usage of CASE in her new SQL. Am currently working with an individual, hoping to help her improve her SQL skills.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |