sptsqlandclr.sql

< SQL Server2005程序设计>

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