User-Defined Functions UDFs

Articles about User-Defined Functions UDFs

1. Cursors and Alternative to the Cursors in SQL Server

   In SQL Server, cursors are database objects that allow you to iterate over a result set (query result) one row at a time, processing each row as needed. Cursors are often used when you need to perform complex row-by-row processing or when dealing with situations where set-based operations are not practical or efficient.

   SenthilkumarJul 26, 2023140,6611,000
2. 

   Using Table Variables Instead of Temporary Tables in SQL Server

   This article demonstrates how to use Table variables in SQL Server instead of temporary tables.

   Karthika PalaniswamyMay 20, 201220,5851,000