为何我的就是不行呢?
-----------------------------------
USE pubs
GOCREATE TABLE #tmp
(
database_name varchar(18),
database_size varchar(18),
unallocated_space varchar(18)
)INSERT INTO #tmp
EXEC sp_spaceusedDECLARE Freespace CURSOR
FOR
SELECT database_name
FROM #tmpOPEN FreespaceFETCH NEXT FROM Freespace WHILE @@FETCH_STATUS=0
BEGIN
FETCH NEXT FROM Freespace
ENDCLOSE Freespace
DEALLOCATE Freespace
GODROP TABLE #tmp
GO服务器: 消息 213,级别 16,状态 7,过程 sp_spaceused,行 196
插入错误: 列名或所提供值的数目与表定义不匹配。
-----------------------------------
-----------------------------------
USE pubs
GOCREATE TABLE #tmp
(
database_name varchar(18),
database_size varchar(18),
unallocated_space varchar(18)
)INSERT INTO #tmp
EXEC sp_spaceusedDECLARE Freespace CURSOR
FOR
SELECT database_name
FROM #tmpOPEN FreespaceFETCH NEXT FROM Freespace WHILE @@FETCH_STATUS=0
BEGIN
FETCH NEXT FROM Freespace
ENDCLOSE Freespace
DEALLOCATE Freespace
GODROP TABLE #tmp
GO服务器: 消息 213,级别 16,状态 7,过程 sp_spaceused,行 196
插入错误: 列名或所提供值的数目与表定义不匹配。
-----------------------------------
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货