SQL Server Day 7 - Text Functions and User Defined Functions
The team discussed the functionalities of SQL, focusing on number and text functions. They also covered the use of the rank function and the ability to create custom functions. The meeting touched on advanced topics, including the use of the CASE statement in SQL for conditional statements. The team also discussed various functions in Excel, particularly those related to handling text and unicode characters. They also considered options for extracting specific data from larger sets using SQL and Excel functions. The team also discussed the creation and usage of scalar functions in SQL, and the development and logic of a function that calculates sales plus profit for a specific orderId. The session ended with a discussion on data normalization and indexing.