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