set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[STPListGoodForBuyInvoice] AS SELECT StockTbl.GoodSyscode,StockTbl.Title FROM StockTbl WHERE (StockTbl.Type <> 1) AND (StockTbl.Type <> 3) ORDER BY StockTbl.Title