sql

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

SELECT COUNT(*) FROM tbl1 WHERE @x = @y

where @x is the field name
but it do not work!
 
And @y would not be a name ? What is the difference ? Keep in mind that @
parameters are placeholders for *values*.

IMO your best bet is to insert the filed name yourself...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

merge certain data from 1 table to another 3
Controlling a WHERE with a checkbox 5
select *...where x in (" & obj & ")" -- what collection obj can I 3
SQLDataSource FilterExpression reset question 1
how to debug.print sql statement with parameter values? 1
Access Access Daisy Chain Linked Tables 0
recursively retrieve records from 2nd table based on records from 1
...efficient method of finding closest date between unrelated tables 8

Back
Top