set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go







create PROCEDURE [dbo].[StpListBarcode]
AS
SELECT     BarcodeTbl.GoodCode, BarcodeTbl.Field1, BarcodeTbl.Field2, BarcodeTbl.SysId, StockTbl.Code AS PartNoCode, StockTbl.BarCode, 
                      BarcodeTbl.Quantity
FROM         BarcodeTbl INNER JOIN
                      StockTbl ON BarcodeTbl.GoodCode = StockTbl.GoodSyscode