V_BATCH_ISLOCKED
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| BATCHID | uniqueidentifier | ||
| ISLOCKED | int |
Definition
Copy
create view dbo.V_BATCH_ISLOCKED as
select
BATCH.ID as BATCHID,
case
when (select APPLOCK_TEST('public',upper(cast(BATCH.ID as nvarchar(36))),'Exclusive','Session')) = 0 then 1
else 0
end as ISLOCKED
from dbo.BATCH