ch14_03_create_managed_objects.sql

来自「sqlserver scripts from ch 14 in zip file」· SQL 代码 · 共 33 行

USE AdventureWorks2008;
GO
-- This following script assumes a valid .net assembly containing the appropriate code
-- has been previously built and installed into SQL Server.

-- Function
CREATE FUNCTION dbo.GetOSVersion()
RETURNS nvarchar(255)
AS 
EXTERNAL NAME DBUtilities.UserDefinedFunctions.OSVersion;

-- Stored Procedure
CREATE PROCEDURE LogInEventLog(@Message nvarchar(255)) 
AS EXTERNAL NAME DBUtilities.StoredProcedures.LogEvent

-- Trigger
CREATE TRIGGER VendorAudit
ON Purchasing.Vendor
FOR UPDATE
AS EXTERNAL NAME DBUtilities.Triggers.LogVendorModification

-- User Defined Type
CREATE TYPE dbo.Point
EXTERNAL NAME DBUtilities.Point

-- Aggregate
CREATE AGGREGATE dbo.Concatenate(@Value nvarchar(4000))
RETURNS nvarchar(4000)
EXTERNAL NAME DBUtilities.Concatenate;