I want to create a column name in a table with space. In MySQL I just created this using the back ticks. But in SQL Server it was show an error. Is there any possibilities to create a column name with space.
I've tried like the following but it doesn't work.
create table space_check
`roll num` int,
Give the column name within Square brackets.
create table space_check ( [roll num] int, name varchar(50) )
It was not a good practice. Try to create using underscore(roll_num) or caps(rollNum).