Database : MS SQL Server 2012
Basedb : cmtypical

I found the same and it seems oracle, anyone has syntax in MS SQL Server command line ?

set SQLFILE=%TEMP%\rur.sql
set RESFILE=%TEMP%\res.txt
echo set pages 0 > %SQLFILE%
echo select ch_doc_id from pcms_chdoc_data; >> %SQLFILE%
echo exit >> %SQLFILE%
sqlplus cm_typical_rept/cm_typical_rept@dim @%SQLFILE%
del /f %SQLFILE%

Rainy Chou
Responses (0)
  • There are no replies here yet.
Your Reply

Recent Tweets

Twitter response: "Invalid or expired token."