You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
12 lines
493 B
12 lines
493 B
|
|
|
|
create proc GetProductInfoByID_Select
|
|
|
|
@ProdID int
|
|
|
|
as
|
|
|
|
select ProdID,ProdName,ProdCost,ProdPrice,ProdStatus,ProdDescribe,ProdDiscount,ProdIMG,ProdDate,ProdSupplierID ,SupplierName,ProdSubType.PSTID,PSTName,ProdMainType.PMTID,PMTName from dbo.ProdMainType,dbo.ProdSubType,dbo.Suppliers,dbo.Product where ProdID=@ProdID and Product.ProdSupplierID=Suppliers.SupplierID and dbo.ProdSubType.PSTID=Product.PSTID and dbo.ProdSubType.PMTID=dbo.ProdMainType.PMTID
|
|
|
|
GetProductInfoByID_Select 1000002
|