INSERT
INTO [QSYSTEM].[Option]
(IdOption, ViewOrder,IdClient,IdParent,Label,Tooltip, Path, Icon,Leaf, Annulled, UserRegister, DateRegister)
VALUES (29,16, 1,NULL, 'Dashboard','Dashboard','/sup/report', '',1, 0, 'dba', (SELECT GETDATE())),
(30,16, 2,NULL, 'Dashboard','Dashboard','/sup/report', '',1, 0, 'dba', (SELECT GETDATE()));
UPDATE [QSYSTEM].[OptionProfile] SET IdProfile= 3 WHERE IdOptionProfile = 26;
UPDATE [QSYSTEM].[OptionProfile] SET IdProfile= 8 WHERE IdOptionProfile = 27;
INSERT INTO [QSYSTEM].[OptionProfile] (IdOption, IdProfile, Annulled, UserRegister, DateRegister)
VALUES (29,3,0,'dba',(SELECT GETDATE())),
(30,8,0,'dba',(SELECT GETDATE()));
INSERT INTO [QSYSTEM].[Authorization]
(IdUser, IdOption, StartDate, EndDate,Annulled, UserRegister, DateRegister)
VALUES (138,29,'2019-01-01','2025-01-01',0,'dba',(SELECT GETDATE()));
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.