|
||||
|
This document presents a sample query that, when run using the SOS-supplied DBISQL utility, produces an EXCEL file that can be used as the data to produce a set of mailing labels in MS Word. There is a document on the SOS web site that describes how to run queries: http://www.sosoft.com/queries/how2010/ Specifically, it selects from […] Normally when you open the DBISQL query utility, you must provide your SOS User ID, your password, and select the data source: Because of the potential security risk, you would not want to default values for your ID and password, but it would be a convenience if there were a way to automatically select […] A Microsoft Linked Server can be created that uses the SQL Anywhere OLE DB provider to obtain access to a SQL Anywhere database. SQL queries can be issued using either Microsoft’s 4-part table referencing syntax or Microsoft’s OPENQUERY SQL function. An example of the 4-part syntax follows. SELECT * FROM SOSDATA..SOS.Patients In this example, SOSDATA […] |
||||
Print Friendly