set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go create PROCEDURE [dbo].[StpListBarcodeForAutoEdit] AS SELECT GoodCode, Field1, Field2, SysId, 0 AS PartNoCode, 0 AS BarCode, Quantity FROM BarcodeTbl