Access parameterised queries upsizing to sql server

[John]

Hi

I am converting Access queries to work with SQL Server syntax as part of
upsizing process. I have several Access queries that use fields form Access
forms as parameters like below;

SELECT <field list>
FROM MyTable
WHERE MyTable.MyField1 = [Forms]![MyAccessForm]![MyField2]

How can I handle such queries in SQL Server context? A code example would be
much appreciated.

Many Thanks

Regards

 

[Uri Dimant]

John
DECLARE @par INT
SET @par=<value>

SELECT <field list>
FROM MyTable
WHERE MyTable.MyField1 = @par

 

[Albert D. Kallal]

Hi

I am converting Access queries to work with SQL Server syntax as part of
upsizing process. I have several Access queries that use fields form
Access forms as parameters like below;

SELECT <field list>
FROM MyTable
WHERE MyTable.MyField1 = [Forms]![MyAccessForm]![MyField2]

How can I handle such queries in SQL Server context? A code example would
be much appreciated.

If you using linked tables, then the above code does not need to be changed.