String literals as column aliases


Hi, I'm using the tool to migrate the DNN database to Azure, and I'm finding that some old store procedures are using "String literals as columns aliases". i.e. SELECT 'Total users'=1. This is not supported on SQL Azure and the migration wizard is not detecting this issue.
There is an easy solution that is to replace the single quotes (') by brackets "[" "]", i.e. SELECT [Total users]=1
If this is automated by the wizard, I think that I don't need to touch manually the SQL scripts before upgrading to Azure.
Thanks for your great work.


ghuey wrote Feb 9, 2011 at 6:30 PM

Hi. You are correct. I will noodle on this and see if I can't come up with something.


wrote Feb 22, 2013 at 12:00 AM

wrote Aug 5, 2014 at 4:36 AM