Re: Commenting in Sql
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Mon, 18 Jun 2007 12:00:54 -0400
Brian Tkatch wrote:
On Mon, 18 Jun 2007 09:21:43 -0400, "Bob Barrows [MVP]"Clever, but there will be an impact on performance since this expression
<reb01501@xxxxxxxxxxxxxxx> wrote:
shiv.shankar.dr@xxxxxxxxx wrote:
I am using Adodb in Vb6 and Access 2000
i want to know how i can have some text commented with in Sql
statement,
It can't. Jet (Access) does not support comments in sql statements
Unless, perhaps, he "cheats" and uses it in the WHERE caluse:
WHERE 'Comment' <> 'This is a comment on how this thing works.'
will need to be evaluated against every row in the table.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- References:
- Commenting in Sql
- From: shiv . shankar . dr
- Re: Commenting in Sql
- From: Bob Barrows [MVP]
- Commenting in Sql
- Prev by Date: Re: Commenting in Sql
- Next by Date: Re: Working with Sessions for functions
- Previous by thread: Re: Commenting in Sql
- Next by thread: Re: Commenting in Sql
- Index(es):
Relevant Pages
|
