Invoke SQL query using the Microsoft BCP utility.

---

 
 ************************************************************************
 * Program: SQLQuery.q *
 * Purpose: Sample program to invoke MS SQL Server query using the BCP *
 * utility. *
 * Syntax.: At command prompt, type: QuikCode myquery.q [Press Enter] *
 * Notes..: For more info on the Microsoft bcp utility, visit the link: *
 * http://msdn2.microsoft.com/en-us/library/Aa174646 *
 ************************************************************************
 
 equate QUERY to "SELECT CSMCaseId, CITInvType, IVTName FROM MyDatabase..MyTable1, MyDatabase..MyTable2, MyDatabase..MyTable3
where IVTTypeID = CITInvType AND CITCaseId = CSMCaseId AND CSMCaseID LIKE '0004444440%' ORDER BY 1"
 
 equate SERVER to "-SMyServer -UMyUserId -PMyUserPsw"
 equate OUTPUT to "MyQuery.txt"
 equate FORMAT to "-r \r\n -t -c"
 display QUERY
 system 'bcp "' QUERY '" queryout ' OUTPUT ' ' SERVER ' ' FORMAT
 system 'start notepad.exe ' OUTPUT
 end 
 
 

---

Back to home