CLR or TSQL? That is the question.
SQL Server Stored Procedures
SQL Server Stored Procedures are SQL statements saved in a database as an object. They can be called interactively through the Query Analyzer, and by other stored procedures.
Cursors in Stored Procedures
First, let’s define a stored procedure for those who don’t already know. A stored procedure is basically a query that you would run frequently that you have saved. The power is that you can have input parameters. For example, if you always execute this query: