MS SQL Code Factory online Help

Return to chapter overview

Both SQL Editor and Visual Query Builder admit to using parameters inside the query text. A parameter is a kind of variable. Its value can be specified just before the query execution in the Parameters window. In the query text the parameter should appear as an identifier with a colon (':') at its beginning, e.g. :param1.

The Parameters dialog is used to specify the query parameters as well as values of the input parameters of procedures or functions before the execution. Enter parameter values and click the OK button to apply the values and execute the query or use the Cancel button to abort the execution.

Note: To allow use parameters in query text, check the corresponding option at the Tools tab of MS SQL Code Factory Options.

Return to chapter overview

SQL Maestro Group wishes you a happy Thanksgiving!

We are pleased to grant you a 20% discount for all our products and bundles till the end of November!

Company news

Jul 7, 2023

MS SQL Server Tools Family upgraded

All software of our Microsoft SQL Server family come now with SQL Server 2022 compatibility.

Apr 10, 2017

Code Factories advanced to version 17.4

New version features colored tabs, new encryption algorithms in data grids, enhanced data input forms, updated data export/import tools and a lot of other useful things.

Sep 20, 2013

Code Factories are updated to version 13.9

New version comes with keyboard interactive SSH authentication, updated Script Runner, redesigned start page, improved SQL editors and data grids, as well as with many other useful things.

More news

Feature of the day

Data management

MS SQL Code Factory provides you with all the features (such as viewing, editing, grouping, sorting and filtering) to analyze the data in the most convenient way.

Visual Query Builder

MS SQL Code Factory allows to design queries as visual diagrams.

MS SQL Code Factory online Help

Query Parameters

Thanksgiving Sale