How to run an SQL Query via the Command prompt for OSQL
Posted on 2014-09-29
We have a validated system that is using using Microsoft SQL Server Desktop Engine.
I need to run a query from the command promt using osql.
I just need to understand how to frame the following, line by line when entering into osql.
SELECT [PatientID], [PackID]
FROM Patient_Visit_Treatments INNER JOIN
Trials_History ON Patient_Visit_Treatments.TrialID = Trials_History.MAPSEC_ID AND Patient_Visit_Treatments.MAPSEC_Version = Trials_History.MAPSEC_Version
Where protocoldesc = '00000000001'