O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Deployment

Before you can test your SQL CLR code, you must deploy the assembly containing it and register the individual functions that you want recognized as stored procedures. A number of deployment methods are at your disposal; we will pause to cover them now, before discussing testing of your stored procedures and the other four basic SQL CLR entities.

Deploying Your Assembly

As mentioned earlier, Visual Studio deploys the SQL Server project version of the sample code when you build, start, or step through the project, or you can use the Build, Deploy option you’ll find on Visual Studio’s main menu. If you’re working with the SQL Server project version of the samples, go ahead and use the Deploy option or one of the Start or Build options in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required