我向某表中添加一行数据,在修改数据界面直接添加 和用语句添加都会出这个错.
删除和修改该表中的数据都没有问题.
其他表没有出现这个问题.No row was updated.
The data in row 9 was not committed.
Error Source :.Net SqlClient Data rovider.
Error message:Create Database statement not allowed within multi-statement transaction.
The Statement has been terminated.请问 这是什么原因造成的?
需要怎么解决?
删除和修改该表中的数据都没有问题.
其他表没有出现这个问题.No row was updated.
The data in row 9 was not committed.
Error Source :.Net SqlClient Data rovider.
Error message:Create Database statement not allowed within multi-statement transaction.
The Statement has been terminated.请问 这是什么原因造成的?
需要怎么解决?
4. 无法新增数据库表
com.sybase.jdbc2.jdbc.SybSQLException: The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'database_name' database. sp_dboption database_name, 'ddl in tran', true
sp_dboption database_name, 'allow nulls by default', true需要重新启动服务这个是sybase数据库吧, 那SQLServer如何修改呢?
然后在执行insert或者在语句之间加上go