Using Parameterized Queries in SQL

Results 1 to 2 of 2

Thread: Using Parameterized Queries in SQL

  1. #1
    Join Date
    Dec 1969

    Default Using Parameterized Queries in SQL

    Hi: I am interested in Using Parameterized Queries in SQL. I am doing a small project now. I want to know what is the best way to put in parameter for the query. I mean I have a drop down list to display the table names. When I click the table name I want somewhere pop up a text box for me to input the parameter value so that the information abou the particular info can display on screen in a table. Please help. <BR>Thank you so much!<BR><BR>Serena<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default You can't parameterize...

    ...the table name or the field names.<BR><BR>Oh, you can, but you end up having to use an EXECUTE in the TSQL which means you aren&#039;t buying enough to matter. You might as well simply build the SQL on the fly in VBS code.<BR><BR>What database are you using? Can&#039;t even do the EXECUTE in most DBs.<BR><BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts