insert into #temp(Name1,rows1,reserved1,date1,index_size1,unused1) exec sp_spaceused @name
那位大哥能把上面的SQL server 语句转成Sybase 语句 谢谢
------解决方案--------------------------------------------------------
- SQL code
--sybase sql语法create table #temp(Name1 varchar(100) null,rows1 varchar(100) null,reserved1 varchar(100) null,date1 datetime null,index_size1 numeric(18,0) null, unused1 char(1) null)insert into #temp (Name1,rows1,reserved1,date1,index_size1,unused1)values ('name1','rows1','reserved1',getdate(),100,'1')select * from #temp