Add a stored procedure item to your database project by right-clicking the project and selecting Add, New Item. From the Add New Item dialog, you select the SQL CLR C# category and then the SQL CLR C# Stored Procedure project item, as shown in Figure 13.29. Let’s name the stored procedure
A new class is added to the project. Listing 13.1 shows the base code that shows up within the new class file. You can add your custom code to the static void routine
Earlier versions of Visual Studio had a separate project type (SQL ...