How to get user input for queries?

To prompt for user input you can use inline Visual Basic .Net code (available in v 2.1 or above). For instance, this query will prompt for input of EventID:

select top 100 * from Application where
EventID=<% return Microsoft.VisualBasic.Interaction.InputBox("Please enter Event ID","Event ID","1053") %>

Feedback and Knowledge Base