Executing a SQL Server Function from Within Access
Posted on
14,636 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 - 4 - Append Query | 32 | |
| Query data with no SQL code (4) | 27 | |
| Query data with no SQL code (7) | 24 | |
| Query data with no SQL code (11) | 60 |
This article will guide you how to configure your Exchange server to use internal DNS servers for internal DNS lookup.This is for Exchange 2013 or higher versions. It is recommended to configure the DNS servers for flawless mail flow.
With the introduction of AlwaysOn Availability Group (AAG) in SQL Server 2012, log shipping seems to be less widely used than before. AlwaysOn Availability Group provides real-time log shipping as transactions are committed/applied to the primary da…
Suggested Courses
Next Video:Query data with no SQL code (2)