set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO






ALTER PROCEDURE [dbo].[STPListStock] 
AS
SELECT     GoodSyscode, Title, Code, BarCode, Type, FstUnit, SecUnit, UnitRate, OrderPoint, SalePrice1, SalePrice2, SalePrice3, SalePrice4, SalePrice5, 
                      VisitorPer, Comment, DiscontPer, UserPrice, GroupName1, GroupName2, Term, Weight, SerialNo, TypeId, GroupId1, GroupId2
FROM         VWCompleteGood