Hello,
how can i use Parameters in Querybuilder
I tried ""Parameter or :Parameter or 'Parameter'
nothing works. The Helpfile said ""Parametername. I think you missed a Character between the ""
best Regards
Stefan
Query and Parameters
With the help of the Edit Parameters dialog you can set parameter values if they exist in your query. For example, you have a query:Open the Edit Parameters dialog and type a value for the @depID parameter. If the parameter value is not entered, the Edit Parameters dialog will appear automatically.
Code: Select all
SELECT
Department.Name,
Department.DepartmentID
FROM
HumanResources.Department
WHERE
Department.DepartmentID = @depID