procedure to take product by catagories?
- MS Sql Server
- 686
- June-28-2018
- by Zaif Ullah
USE [saudiphone]
GO
/****** Object: StoredProcedure [dbo].[Product_LookUp_CategoryID] Script Date: 6/28/2018 2:22:10 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[Product_LookUp_CategoryID]
@CategoryID int
as
begin
SELECT TOP (8) * FROM Product where CategoryID=@CategoryID order by ProductID desc
end
