Beginning with WinSQL Professional version 2.0, parameters can be accepted in queries. Any text that is preceded by two colons (::) is considered a parameter, and users are prompted to enter a value when the query is run. In addition, WinSQL Professional stores the values for previously-used parameters so that the user does not have to type them every time.
Notes:
·Once a value has been specified for the first parameter in a query, you can press [Enter] to move to the next parameter. WinSQL Professional attempts to determine the data type for the subsequent parameters; however, the default data type can be determined by selecting a type from the list.
·Parameter queries cannot be used to export data.