Using Columns Containing non-Identifier Characters in SQL

Question

hi, can i write a select statement i n SQL Server like:

select * from emp where Emp Name='joy' or select * from emp where EmpId/Sno=7

whether spaces,special charaters like a comma are allowed in that specified select statement when the column name is having them.

Thanks in advance..

Answer 1

Try

select * from emp where "Emp Name"='joy' or "EmpId/Sno" = 7

If column names have "funny" characters put them in double quotes (you can put them in double quotes even if they don't have "funny" characters)

Answer 2

Spaces and other characters are allowed, but you have to delimit the identifier with square brackets or doublequotes:

select * from emp where [Emp Name]='joy'