Re: Select

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "John Bell" <jbellnewsposts@xxxxxxxxxxx>
Date: Wed, 13 May 2009 20:55:07 +0100

"coady" <coady@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:76968BD5-6317-46C8-A482-9587BBA41A3B@xxxxxxxxxxxxxxxx

Thank you!! It worked.

I am a newbie. Could you explain what you meant by "keyword"?
Becuase the actual query I did was
select AccountCodeID,MaskID,Desc from dbo.AccountCode

After adding the brackets as following, it worked
select AccountCodeID,MaskID,[Desc] from dbo.AccountCode

Lookup the subject "Reserved Keywords" in books online or at http://msdn.microsoft.com/en-us/library/ms189822.aspx
and "Delimited Identifiers" http://msdn.microsoft.com/en-us/library/ms176027.aspx

John

.

Follow-Ups:
- Re: Select
  - From: coady

References:
- Select
  - From: coady
- Re: Select
  - From: Tom Cooper
- Re: Select
  - From: coady

Prev by Date: Problem resolved: Copy to Output: An attempt to attach an auto-named database for file C:\YOURUSERNAME\YOURPATH\YOURDATABASEHERE failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Next by Date: Re: Select
Previous by thread: Re: Select
Next by thread: Re: Select
Index(es):
- Date
- Thread

Relevant Pages

Re: Select
... "John Bell" wrote: ... > I am a newbie. ... > Becuase the actual query I did was ...
(microsoft.public.sqlserver.server)
Re: Escape character weirdness
... The problem of course is that you can't return brackets from the ... Sql Server uses brackets '' to escape. ... I tried a 'LIKE ' query, ... PreparedStatement p = c.prepareStatement("insert into #foo ...
(microsoft.public.sqlserver.jdbcdriver)
Re: Help with Date Parameter
... "Enter Business Date of Report"? ... When I run the query, records for all dates are displayed instead of just ... You need to set the query criteria to: ... Brackets will not be necessary (but are still good ...
(microsoft.public.access.queries)
Re: can this be done with a subquery?
... Your SQL is fine but it's approximately my first query. ... MaxAs LatestDate ... *further brackets* within a subquery ...
(microsoft.public.access.queries)
Re: Now it works... now it doesnt... What is up with this query
... I would like to use this query again. ... FROM [SELECT ItemNumber, CountAS Stores ... The "save parser" chokes on any brackets within a subquery ...
(microsoft.public.access.queries)