11 lines
209 B
Transact-SQL
11 lines
209 B
Transact-SQL
USE AdventureWorks;
|
|
|
|
GO
|
|
CREATE PROCEDURE Sales.GetDiscounts
|
|
AS
|
|
BEGIN
|
|
SELECT Description, DiscountPct, Type, Category, StartDate, EndDate, MinQty, MaxQty
|
|
FROM Sales.SpecialOffer;
|
|
END
|
|
|
|
EXEC Sales.GetDiscounts; |