SQL Server and columns with spaces

Owned by Lee Russell (Unlicensed)
Last updated: Mar 15, 2013 by Raymond Ha (Unlicensed)
1 min read

If you can avoid it, don't use column names with spaces. However, some tools do this automatically. To make SQLDataSource work with tables with spaces, use "sql.sqlserver.quoteColumnNames: true" in server.properties, as explained here:Â