TRUNCATE TABLE command not allowed within multi-statement transaction

翻译过来是：TRUNCATE TABLE命令不允许在多语句事务。

原因可能是有其他人也正在操作数据库的这几个表，导致不能重复

分开一条一条执行或稍后执行即可

 

网上的资料显示也有这样说的：Sybase statest that the TRUNCATE command is never allowed in a transaction and the DROP command only if the "ddl in tran" option is set to "true". - See more at: http://codeverge.com/sybase.ase.general/truncate-table-command-not-allowed-within/799757#sthash.Z0PZhYUm.dpuf

 

解决办法是:在数据库参属性参数中勾选上"ddl in tran"选项,或者执行下面语句:

sp_dboption 'ddl in tran',true1

如果之后再有其他发现会持续添加