📄 示例13-5.sql
字号:
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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -