Download
1 / 6
60 likes | 239 Vues
Enhance your SQL skills with advanced tips introduced in SQL Server 2008 and 2012. Learn about the IIF function for conditional logic, which allows for concise boolean evaluations. Explore the CONCAT function to seamlessly concatenate strings, simplifying string manipulation tasks. Additionally, understand compound operators for refined expressions and the table value constructor for efficient data handling. Utilize these features to write cleaner, more efficient SQL code and streamline your database operations. Dive deeper into these powerful SQL functionalities!
E N D
5 SQL TIPS you may not know Minette Steynberg Minettes@Pkey.co.za Primary Key Consulting
Logical condition USING IIF • Introduced in SQL Server 2012 • IIF ( boolean_expression, true_value, false_value ) http://msdn.microsoft.com/en-us/library/hh213574.aspx
Concatenation USING CONCAT • Introduced in SQL Server 2012 • CONCAT ( string_value1, string_value2 [, string_valueN ] ) http://msdn.microsoft.com/en-us/library/hh231515.aspx
Compound operators • Introduced in SQL Server 2008 • expression operator expression http://msdn.microsoft.com/en-us/library/cc645922.aspx
Table value constructor • Introduced in SQL Server 2008 Batch Replicator http://msdn.microsoft.com/en-us/library/dd776382.aspx
Template Explorer http://msdn.microsoft.com/en-us/library/ms174169.aspx
