13 lines
303 B
Transact-SQL
13 lines
303 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_read_guild_server]
|
|
(
|
|
@group_id SMALLINT
|
|
,@server SMALLINT
|
|
)
|
|
|
|
as begin
|
|
|
|
set nocount on
|
|
set transaction isolation level read uncommitted
|
|
|
|
select guild_id, room_id from GuildTable where [server] = @server and group_id = @group_id and [block_type] = 0
|
|
end
|