set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[STPGoodPartNoList] 
AS
SELECT     Code
FROM         StockTbl
ORDER BY Code