In the last two weeks, SQL Shack articles focused on SQL Server Business Intelligence, SQL Server cursors, and SQL Server Management Studio configuration.
In SQL Server Business Intelligence – Using recursive CTE and persisted computed columns to create a calendar table, we showed how to create a calendar table that can help you work with dates and fill it. We provided scripts to create the table using computed column syntax and to insert every day in a specified time range using a recursive CTE query.
When to use cursors and how to write the code behind them is explained in SQL Server cursor tutorial. The article also gives code for a simple example: loop through the contents of a table and select the description of each ID found.
How to configure SQL Server Management Studio (SSMS) in seven easy steps is shown in SQL Server Management Studio tutorial – Configuring the environment. See how to get the best of SQL Server Management Studio, find the right features, and configure the startup options, such as Query tab, Object Explorer position, keyboard settings and shortcuts.
June 15, 2014