Комментарий

• Свойства страницы (1 изменено, 0 добавлено, 0 удалено)

Подробности

Свойства страницы

Содержимое

...	...	@@ -4,27 +4,26 @@
4	4
5	5	{{code language="sql"}}
6	6
7		-SELECT
8		- DB_NAME(er.database_id) AS DB_Name,
9		- er.start_time,
10		- er.session_id,
11		- er.status,
12		- er.command,
13		- - - performance: er.reads + er.writes AS IO,
14		- er.logical_reads,
15		- er.cpu_time,
16		- er.total_elapsed_time,
17		- - - waits: er.blocking_session_id,
18		- er.wait_type,
19		- er.wait_time,
20		- er.wait_resource,
21		- - - query: qt.text,
22		- qp.query_plan
23		-FROM
24		- sys.dm_exec_requests as er
25		- CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) qt
26		- CROSS APPLY sys.dm_exec_query_plan(er.plan_handle) qp
27		-WHERE
28		- er.database_id = DB_ID('MyBase')
	7	+DECLARE @key INT = 12
	8	+DECLARE @msg NVARCHAR(MAX) = 'L2'
	9	+
	10	+BEGIN TRAN
	11	+ IF EXISTS (
	12	+ SELECT *
	13	+ FROM DBO.LOG2ENTITY WITH (UPDLOCK, SERIALIZABLE)
	14	+ WHERE ID = @key
	15	+ )
	16	+ BEGIN
	17	+ UPDATE DBO.LOG2ENTITY
	18	+ SET
	19	+ Message = @msg
	20	+ WHERE ID =@key
	21	+ END
	22	+ ELSE
	23	+ BEGIN
	24	+ INSERT INTO DBO.LOG2ENTITY (Message)
	25	+ VALUES (@msg)
	26	+ END
	27	+COMMIT TRAN
29	29
30	30	{{/code}}