9 lines
282 B
Transact-SQL
9 lines
282 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_read_new_mail_exist]
|
|
@character_id [uniqueidentifier]
|
|
as
|
|
set nocount on
|
|
set transaction isolation level read uncommitted
|
|
|
|
select count(*) as ct FROM dbo.MailTable with (nolock) where [character_id] = @character_id and [is_open] = '0';
|
|
|
|
return @@error
|