读书人

sysbase中的select ino,该如何处理

发布时间: 2012-04-06 12:22:24 作者: rapoo

sysbase中的select ino
表tab_tem已经存在
SQL语句: select a.* into tab_tem from sysobjects_copy a,sysobjects_j b
where a.type='U' and b.type='U' and a.name=b.name //and a.name='check_method_1'
group by a.name;执行后
错误:You can't run SELECT INTO in this database. Please check with the Database Owner.
不知是什么问题?

[解决办法]
use master
go
sp_dboption 'dbname','select into',true
go
use dbname
go
checkpoint
go


dbname换为你的数据库的名字

读书人网 >Sybase

热点推荐