bash - Sqlcmd:'var=1':参数无效。使用 Bash 脚本
问题描述
这是我在 stackoverflow 中的第一篇文章:D
我在使用 sqlcmd 在 sql 文件中传递变量时遇到问题。
sqlcmd -S "$host" -U "$username" -P "$password" -d "$dbname" -s "║" -v test=1 -i $productQuery -h -1 | while IFS="," read -r row
do
# some stuff here..
done
它有错误“Sqlcmd:'test = 1':无效参数。输入'-?' 求助。”。提前致谢!:D
解决方案
|while ...
导致错误。我想出了不同的解决方案来解决我的问题。感谢@user1934428
推荐阅读
- javascript - 我的函数在第一条语句后没有返回运行
- python - CNN train with weird result: VAL LOSS increases while VAL ACCURACY / PRECISION / RECALL also increase
- selenium - Trying to click a button with Selenium Webdriver using Cucumber-JS
- html - CSS background color not showing up
- c# - How to Register Permission to the database and grant to a role in asp.net boilerplate
- c# - Redirect to Login wrong when running .NET Core 3.1 on Elastic Beanstalk
- javascript - Chartjs xaxis标签自动减少禁用
- spring-boot - Error resolving template in a Spring boot Web Application when deployed to external tomcat
- javascript - 循环遍历数组中的 json 响应
- azure-cosmosdb - DocumentClient CreateDocumentQuery throws 'AsSQL' is not supported