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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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...- srim
- Post #4
- Forum: Microsoft SQL Server: Programming
-
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- srim
- Post #3
- Forum: Microsoft SQL Server: Programming
-
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...- srim
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
