I have a (sql server) database with a table containing logo files of companies. For a better performance only the filename is saved to the table (so it is not a BLOB field). All image files are in the same directory. For example the path is "e:\images" and the filename is in field strPictureLogo of tblCompany. Is it possible to build a sql statement that retrieves the image files, so that the view contains the images?
in sql 2000 you could write a UDF to pull the File into a temporary blob in sql and include it into a view, but that'll give you a performance far below any blob field natively in the db.
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
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 pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.