Access parameterised queries upsizing to sql server

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
John
DECLARE @par INT
SET @par=<value>

SELECT <field list>
FROM MyTable
WHERE MyTable.MyField1 = @par
 
John said:
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.
Click to expand...

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