sql server linux查询,linux – freeTDS bash：在Microsoft SQL Server中执行sql查询

我不确定你的样品是如何起作用的.

这是我的bash脚本示例：

echo "USE dbname .... exit" > tempfile | TDSVER=8.0 tsql -H servername -p 1433 -D dbname -U domain\\Administrator -P password < tempfile

# ------------------------------------^^^^ ---- pipe char?

尝试使用’;’焦炭.

echo "USE dbname .... exit" > tempfile ; TDSVER=8.0 tsql -H servername -p 1433 -D dbname -U domain\\Administrator -P password < tempfile

# ------------------------------------^^^^ ---- semi-colon

更好的是,使用shell的“here documents”.

TDSVER=8.0 tsql -H servername -p 1433 -D dbname -U domain\\Administrator -P password <

USE dbname

GO

delete from schema.tableA where userid > 5

go

delete from schema.tableB where userid > 5

go

delete from schema.tableC where ID > 5

GO

exit

EOS

IHTH.

当前命令行输入：

echo "delete from table where userid > 5

go

delete from table where userid > 5

go

delete from table where ID > 5

GO

exit" < /tmp/tempfile; TDSDUMP=/tmp/freetds.log TDSVER=8.0 tsql -H servername -p 1433 -D dbname -U Administrator -P password <