27-06-2018, 01:56 PM
Hello
Is it planned to fix the following SQL "issues" in the next version?
[We use ASG 11.0.5988.1 in combination with SQL Server 2016 SP1
We've used the Microsoft Data Migration Assistent to create an assessment.]
issues:
tables:
ItemProperties --> column Data is ntext => change to nvarchar(max)
Items --> column Description is ntext => change to nvarchar(max)
Logs --> column Details is ntext => change to nvarchar(max)
procedures:
"Old WHERE syntax"
Best regards,
Simon
Is it planned to fix the following SQL "issues" in the next version?
[We use ASG 11.0.5988.1 in combination with SQL Server 2016 SP1
We've used the Microsoft Data Migration Assistent to create an assessment.]
issues:
tables:
ItemProperties --> column Data is ntext => change to nvarchar(max)
Items --> column Description is ntext => change to nvarchar(max)
Logs --> column Details is ntext => change to nvarchar(max)
procedures:
"Old WHERE syntax"
Code:
ALTER PROCEDURE [dbo].[SecurityGroupAssignmentsForAllItemsGet] AS
SELECT * FROM SecurityAssignment Assignments, SecurityGroups Groups
WHERE
Assignments.GroupId = Groups.GroupId
ORDER BY
ItemId, Groups.GroupId
--to:
ALTER PROCEDURE [dbo].[SecurityGroupAssignmentsForAllItemsGet] AS
SELECT * FROM SecurityAssignment Assignments
LEFT JOIN SecurityGroups Groups
ON Assignments.GroupId = Groups.GroupId
ORDER BY
Assignments.ItemId, Groups.GroupId
Best regards,
Simon