SQL Server is ready to except any thing enclosed in square bracket. U can use balnk spaces also.U can use reserve words also as identifiers in this way.
Any table name, Server name, DB name with -, blank space etc which are not valid as per identifier naming convention must be enclose within .
select * from employee a,
This will work perfectly with SQL Server. But yes I am not sure how ur application is database nutral with such things.
Hope u got the point