15 lines
361 B
Transact-SQL
15 lines
361 B
Transact-SQL
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
|