Current .Net Version: 2.0.50727
(select below)
.Net Framework
ADO.NET
ASP.NET/Web Forms
C#
Certifications
SQL Server
Visual C#
Windows Forms
XML Web Services
Mike's C#, VS.NET and SQL Blog
T-SQL Scripts
CREATE ASSEMBLY
-- Tested with SQL Server 2005 9.00.852 -- Adds an assembly to SQL Server and then adds -- and SPROC that calls a method in the assembly. -- Add the assembly to SQL Server: CREATE ASSEMBLY DotNetFunSQLServerSProc FROM 'C:\Inetpub\wwwroot\dotnetfun\code\2.0\DotNetFun\SQLServer\SProc\DotNetFun.SQLServer.SProc.dll' WITH PERMISSION_SET = SAFE GO -- Create a stored proecdure that calls the -- PrintMessage method in the assembly: CREATE PROC sp_DotNetFunSProcPrint @Message NVARCHAR(255) AS -- Call the PrintMessage in the assembly and pass -- it @Message: EXTERNAL NAME DotNetFunSQLServerSProc.[DotNetFun.SqlServer.SProc].PrintMessage GO -- Execute the stored procedure: EXEC sp_DotNetFunSProcPrint "Hello from DotNetFun.com!"
Open/Save
|
E-mail
|
Back
COPYRIGHT/DISCLAIMER
|
CONTACT US
Current .Net Version: 2.0.50727
Current .Net Version: 2.0.50727
