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