Categoría:
BEGIN TRANSACTION
DECLARE @CurrentDate DATETIME = GETDATE()
DECLARE @AdminID UNIQUEIDENTIFIER
SELECT @AdminID = UserId
FROM SUMACUserDetail
WHERE UserName = 'ADMINISTRADOR'
INSERT INTO SUMACCatalogValue (
Code
,DescriptionES
,CatalogTypeCode
,IsLocked
,CreatedDate
,CreatedBy
,ModifiedDate
,ModifiedBy
)
VALUES (
56
,'Búsqueda de Aranceles'
,1
,1
,@CurrentDate
,@AdminID
,@CurrentDate
,@AdminID
)
COMMIT;
Privilegio (lectura):
BEGIN TRANSACTION
DECLARE @CurrentDate DATETIME = GETDATE()
DECLARE @AdminID UNIQUEIDENTIFIER
SELECT @AdminID = UserId
FROM SUMACUserDetail
WHERE UserName = 'ADMINISTRADOR'
INSERT INTO SUMACPrivilege (
PrivilegeCode
,CategoryCode
,ActionCode
,CreatedDate
,CreatedBy
,ModifiedDate
,ModifiedBy
)
VALUES (
62
,56
,1
,@CurrentDate
,@AdminID
,@CurrentDate
,@AdminID
)
COMMIT;