set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


create PROCEDURE [dbo].[StpLockDoc]
@FromDate char(8) = null,
@ToDate char(8) =null,
@FromCode int=null,
@ToCode int=null,
@lock bit
AS
UPDATE    DocTbl
SET              Lock = @lock
WHERE     (DocDate BETWEEN @todate AND @fromdate) OR
                      (SysCode BETWEEN @fromCode AND @tocode)