Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: srim
  • Order by date
  1. srim

    Query help: Access 2000 to SQL7

    Hi timmah13, I am also in the same process of converting queries from Access 2000 to SQL Server 2000. Have you gone through converting update statements with right join from access to sql server. If so please let me know how to convert the following: 1.UPDATE table1 AS a RIGHT JOIN table2 AS...
  2. srim

    convert access queries to sql server(T-SQL)

    Datatype is date/time in access and in where condition it is looking for the date > date1. Do we have to split UPDATE statement with RIGHT JOIN into 2 statements or does it work has you mentioned. Thanks, Srim
  3. srim

    convert access queries to sql server(T-SQL)

    Hi, I'm trying to convert all the queries in Access database and the queries in the VB program to T-SQL(sql server) format. This is because we are moving the database from access to sql server. I need to know how to change the following queries to t-sql: 1.UPDATE table1 AS a RIGHT JOIN table2...

Part and Inventory Search

Back
Top