This error occurs in SQL Azure because of deprecated syntax.
ErrorIt normally appears in SQL such as this:
select
dnn_Announcements.ItemID,
dnn_Announcements.ModuleID,
dnn_Announcements.Title,
case when dnn_Files.FileName is null then dnn_Announcements.URL else dnn_Files.Folder + dnn_Files.FileName end as Url,
dnn_Announcements.ExpireDate,
dnn_Announcements.Description,
'CreatedByUser' = dnn_Users.FirstName + ' ' + dnn_Users.LastName,
dnn_Announcements.CreatedDate,
dnn_Announcements.ViewOrder,
dnn_UrlTracking.TrackClicks,
dnn_UrlTracking.NewWindow
from dnn_Announcements
CauseThe error occurs in the usage in this string:
'CreatedByUser' = dnn_Users.FirstName + ' ' + dnn_Users.LastName,This syntax is no longer supported ; use 'AS
name' instead
FixChange the literal column renaming to use the 'AS' syntax.
dnn_Users.FirstName + ' ' + dnn_Users.LastName as CreatedByUser,