示例13-5.sql

SQL Server 业已成为最为流行的几大数据库之一

Alter Database Northwind
SET TRUSTWORTHY ON
Go
CREATE ASSEMBLY InsertCategories
FROM  'D:\sqldemo\InsertCategories\InsertCategories\bin\Debug\InsertCategories.dll'
WITH permission_set = UNSAFE
GO 

CREATE PROC dbo.InsertTableCategories
(
   @lCategoryName NVARCHAR(30),
   @lDescription  NVARCHAR(30)	
)
AS EXTERNAL NAME InsertCategories.[InsertCategories.InsertCategories].InsertTableCategories
go  
USE Northwind
DECLARE @lCateName AS NVARCHAR(30)
SET @lCateName ='fruit'
DECLARE @lDescription AS NVARCHAR(30)
SET @lDescription ='apple,peach,grape,orange'
exec InsertTableCategories @lCateName,@lDescription  
SELECT * FROM Categories