Creating and Executing a SQL Pass-thru Query
Posted on
12,204 Points
5:15
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pass-thru query. This video covers the basics of creating and working with pass-thru queries.
Video Steps
1. The video first shows the viewer how to create a pass-thru query in Access.
2. The data in the SQL Server table that the pass-thru query will return is displayed in SQL Server Management Studio.
3. We then create the T-SQL string in the pass-thru query and create an ODBC data source that will be used to connect to the SQL Server.
4. Finally, we store the ODBC connection string in the pass-thru query so that the pass-thru query can be run at any time.
0 Comments
Suggested Videos
| Title | Views | Activity |
|---|---|---|
| Query data with no SQL code (2) | 30 | |
| Query data with no SQL code (3) | 27 | |
| Query data with no SQL code (5) | 19 | |
| Query data with no SQL code (11) | 60 |
The UNION ALL (or UNION) operator is used to combine different result sets. This article focuses on handling the UNION ALL operator in a better way.
I wrote this article because I was unable to find an article on this here on EE. Read on for step-by-step instructions on how to create a custom command ribbon in your office applications that not only make them look more professional but also prot…
