procedure to take related products?
By Zaif Ullah   Posted on June-28-2018 674
MS Sql Server
USE [saudiphone]
GO
/****** Object: StoredProcedure [dbo].[Product_LookUp_SubCategoryID] Script Date: 6/25/2018 4:58:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[Product_LookUp_SubCategoryID]
@SubCategoryID int
as
begin
SELECT TOP (8) * FROM Product where SubCategoryID=@SubCategoryID order by ProductID desc
end
By zaifullah489-000001   28-Jun-2018
Views 674