UFN_BATCHGETCUSTOMVALIDATEPROCEDURE
Return
| Return Type |
|---|
| nvarchar(200) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHTEMPLATEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_BATCHGETCUSTOMVALIDATEPROCEDURE(
@BATCHTEMPLATEID uniqueidentifier
)
returns nvarchar(200)
with execute as caller
as begin
declare @PROCEDURENAME nvarchar(200) = null
select @PROCEDURENAME = PROCEDURENAME
from dbo.BATCHTEMPLATE
inner join dbo.BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
inner join dbo.SQLPROCEDURECATALOG on BATCHTYPECATALOG.VALIDATIONSPECID = SQLPROCEDURECATALOG.ID
where BATCHTEMPLATE.ID = @BATCHTEMPLATEID
return @PROCEDURENAME
end