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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using Microsoft Access 2010 linked table to edit Oracle table data
Does anyone know of any issues or risks that may be encountered using Access 2010 linked tables to update, insert and delete records from the Oracle tables? Does anyone know how and when the session to the Oracle database is released when using the Access 2010 linked tables? I am testing...- SarahNZ
- Thread
- Replies: 1
- Forum: Oracle: All versions
-
SQL query syntax with joins question
thanks!- SarahNZ
- Post #4
- Forum: Microsoft SQL Server: Data Transformation Services
-
SQL query syntax with joins question
With the join syntax used below is "k" a temporary table? What is 'k' and 'd'and how and where is it stored? Code example: select x.name, x.addressl1, x.city into #temptable from server.SQLServer.database.tablename x join ( select name, addressl1, city, count(*) as instances from...- SarahNZ
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Data Transformation Services
