T-SQL Tips (MSSQLTips 7/30/2024)

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [SQL Quick Reference Guide]( This guide outlines various aspects of working with SQL along with several links to resources to help you better understand how to use the SQL language.... [Read Now]( [mssqltips image]( [SQL Server Cursor Example]( A SQL Server cursor is a set of T-SQL logic to loop over a predetermined number of rows one at a time. The purpose for the cursor may be to update one row at a time or perform an administrative process such as SQL Server database backups in a sequent... [Read Now]( [mssqltips image]( [SQL Server Cross Apply and Outer Apply]( Learn about SQL Server CROSS APPLY and OUTER APPLY and how they differ from regular JOINs and how to use these along with scripts and a video. ... [Read Now]( RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( [SQL CASE Statement in Where Clause]( Learn about different ways you can use a CASE statement in the WHERE clause for a T-SQL statement with these several examples.... [Read Now]( [mssqltips image]( [Rolling up Multiple Rows into a Single Row and Column]( Learn how to roll-up multiple rows into one row and one column with concatenation in SQL Server with FOR XML, STUFF and STRING_AGG. ... [Read Now]( [mssqltips image]( [Using MERGE in SQL Server to Insert, Update and Delete]( In this tip we look at an example to help you better understand how the SQL Server MERGE statement works.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]