sptsqlandclr.sql

来自「< SQL Server2005程序设计>」· SQL 代码 · 共 19 行

CREATE PROCEDURE dbo.spTSQLAndCLR 
	(
	@VendorId int
	)
AS

	SET NOCOUNT ON

	DECLARE	@ContactCount int

	SELECT     ProductID, VendorID, AverageLeadTime, StandardPrice, LastReceiptCost, LastReceiptDate, MinOrderQty, MaxOrderQty, OnOrderQty, UnitMeasureCode, 
						  ModifiedDate
	FROM         Purchasing.ProductVendor
	WHERE     (VendorID = @VendorId)

	EXEC spSQLCLR

	SELECT dbo.fnHelloWorldCh09() As HelloWorld