sptsql.sql

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

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)