CREATE PROCEDURE [dbo].[up_read_item_dropgroup] @dropgrouptype int, @dropgroup_id int as set nocount on set transaction isolation level read uncommitted select dropgrouptype, item_dropgroup_id, item_range, item_seed from dbo.ItemDropGroupTable with (nolock) where item_dropgroup_id = @dropgroup_id and dropgrouptype = @dropgrouptype; return @@error