InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 10:30:16 GMT20http://www.sqlservercentral.com/Forums/Topic1233970-145-1.aspx[quote][b]llawws (1/11/2012)[/b][hr]Thanks alot we have fix the issue.we have space with column name before and after.it was enclosing after including braces[/quote]No, wait: you mean you have a column named " something "? Who in his right mind could ever name a column that way?Wed, 11 Jan 2012 13:58:03 GMTspaghettidbahttp://www.sqlservercentral.com/Forums/Topic1233970-145-1.aspxThanks alot we have fix the issue.we have space with column name before and after.it was enclosing after including bracesWed, 11 Jan 2012 08:55:29 GMTSimha24http://www.sqlservercentral.com/Forums/Topic1233970-145-1.aspxMaybe you need to do:[code="sql"]SELECT * FROM schema.table[/code]If the table is not in your default schema, it won't just show up automatically.Wed, 11 Jan 2012 08:17:12 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1233970-145-1.aspxMay be an issue with the column name.Have you tried enclosing the name in square brackets? [code]SELECT [Column Name] FROM SomeTable[/code]Wed, 11 Jan 2012 07:56:06 GMTspaghettidbahttp://www.sqlservercentral.com/Forums/Topic1233970-145-1.aspx[quote][b]llawws (1/11/2012)[/b][hr]when i am using bellow query i am getting problem.select * from table --> no issue table result is showing.where as when i use the column it was showing invalid column name.1. Column names are correct2. no deny select column from table is not working[/quote]Not a lot of detail to go on here. I think you are saying that when you select from the table with no where clause you get results but when you add your where clause you get no results? That means you don't have any data that meets the condition of the where clause.Can you post your actual query? That would provide a lot more information.Wed, 11 Jan 2012 07:55:54 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1233970-145-1.aspxPost table definition (the CREATE TABLE statement) and the query that you're using with the column nameWed, 11 Jan 2012 07:55:49 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1233970-145-1.aspxwhen i am using bellow query i am getting problem.select * from table --> no issue table result is showing.where as when i use the column it was showing invalid column name.1. Column names are correct2. no deny select column from table is not workingWed, 11 Jan 2012 07:30:46 GMTSimha24