Search This Blog

Wednesday, August 14, 2013

How to read a table without name in sql server

we can't create table without name or name as blank space, but after creating a table we can rename it with a blank space.
Sql Server doesn't support table name with two or more blank space, thus there is no resigns of conflict with name. 

now the queries for the table with name as blank space would be like this.

select * from []

Regards
Asit kumar