sptsql.sql

< SQL Server2005程序设计>

CREATE PROCEDURE dbo.spTSQL
	(
	@VendorId int
	)
AS

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