SQL Server - Convert sql server query to ms access query

Asked By Kishore Rajendran on 25-Feb-14 03:23 AM

Hi all,

I want to convert an sql query to ms access compatible.

SQL Query

Collapse | http://www.codeproject.com/Questions/732980/Convert-sql-server-query-to-ms-access-query#

Declare @myVar int=0;
update tbl_Project
SET @myvar = project_Id = @myVar + 1

Any help will be very much thankfull.

Kishore R