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)