Running SQL query in batch file Error.
HI All,
SQLCMD -DESKTOP-SDMAAAAA\AAAAAAA DESKTOP-SDAAAA\Suresh Pasham -DelayVerification -E -Q "select * from [adv].[Route] where convert(date,CreatedDate)=convert(date,getdate())" -s "," -o "C:\Users\Suresh Pasham\source\DailySales.csv"
This is my query in my batch, when I run the batch file I am getting error : Invalid object name 'adv.Route'.
Outside of batch file, in sql instance it executes well. Thanks
can any answer please.
SQLCMD -DESKTOP-SDMAAAAA\AAAAAAA DESKTOP-SDAAAA\Suresh Pasham -DelayVerification -E -Q "select * from [adv].[Route] where convert(date,CreatedDate)=convert(date,getdate())" -s "," -o "C:\Users\Suresh Pasham\source\DailySales.csv"
This is my query in my batch, when I run the batch file I am getting error : Invalid object name 'adv.Route'.
Outside of batch file, in sql instance it executes well. Thanks
can any answer please.
A friendly place for developers to meet other devs, ask questions, get help, and just have a good time 🙂.
36,263Members
Resources
Recent Announcements
Similar Threads
Was this page helpful?
