Tag Archives: SQL Query

Recursive user defined function in SQL Server

Introduction In this post I will explain how write a recursive user defined function in SQL Server Description Recursive function is a function which calls itself for a certain number of times based on some business logic. We will create a simple recursive user defined function for calculating factorial of a number. Factorial of a… Read More »

How to write data of an SQL Server table to an XML file using C#

Introduction In this article I will discuss how to write data of an SQL server table to an XML file using C# Description I have an Employees table in Northwind database with some sample data that we are going to write in an XML file. You can download Northwind and pubs sample databases from here… Read More »