This question is not related to SDAC functionality, but to specificities of Azure SQL Database architecture.
The issue is that CREATE LOGIN and ALTER LOGIN won't take the variable. The way around this is to use Dynamic SQL:https://social.msdn.microsoft.com/Forum ... ransactsql