16 lines
325 B
Transact-SQL
16 lines
325 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_get_character_simpleinfo]
|
|
@name nvarchar(16),
|
|
@server smallint
|
|
as begin
|
|
|
|
set nocount on
|
|
set transaction isolation level read uncommitted
|
|
|
|
select [Name]
|
|
,[Class]
|
|
,[Job]
|
|
,[Level]
|
|
|
|
|
|
from CharacterTable WITH (NOLOCK) where Name = @name --and [server] = @server
|
|
end
|