1
Vote

String literals as column aliases

description

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.

comments

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.

Thanks,
George