set-based-operations – CodeRavo

Generating a Sequence of Dates in SQL Server Without Loops

Introduction When working with databases, there are often scenarios where you need to generate a sequence … Generating a Sequence of Dates in SQL Server Without LoopsRead more

date-sequences, maxrecursion, performance, recursive-cte, set-based-operations, SQL Server, table-variables

Iterating Through Result Sets in SQL Server

SQL Server, like many relational database management systems, is optimized for set-based operations. However, there are … Iterating Through Result Sets in SQL ServerRead more

cursor, database programming, iteration, loops, performance, set-based-operations, SQL Server, table-variable, temporary-table

Iterating Over Table Variables in T-SQL Without Using Cursors

In Transact-SQL (T-SQL), table variables are a powerful feature that allows you to store and manipulate … Iterating Over Table Variables in T-SQL Without Using CursorsRead more

cursors, identity-columns, iteration, performance optimization, set-based-operations, T-SQL, table-variables, Temporary Tables, while loop

Iterating Over Result Sets in SQL Server

SQL Server, like many relational database systems, excels at set-based operations. This means performing actions on … Iterating Over Result Sets in SQL ServerRead more

cursor, iteration, performance, set-based-operations, SQL Server, T-SQL, table-variable, while loop