Executing a SQL Server Function from Within Access
Posted on
14,600 Points
5:16
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access is a SQL Server function. After linking to a view based on a scalar-valued function, or creating a pass-through query that executes a table-valued function, you can utilize the results of both types of functions.
Suggested Videos
| Title | Views | Activity |
|---|---|---|
| Shuffle - 3 - Table Design | 23 | |
| Query data with no SQL code (1) | 46 | |
| Query data with no SQL code (4) | 26 | |
| Query data with no SQL code (10) | 36 |
This article discusses various scenarios that can end up in a DBCC CHECKDB process getting stuck in a Killed/Rollback state and how to resolve the problem.
A while back I wrote an article about the Power Query Editor and PowerBI (https://www.experts-exchange.com/articles/37938/PowerBI-and-the-Query-Editor-Save-time.html). I have realized that my coworkers primarily use Excel and So have changed the ar…
Suggested Courses
Next Video:Query data with no SQL code (1)