这段代码有什么问题！？

Question

alter function _sys_getTreeSQL (@formID int)
returns @table table(treeSQL varchar(1500),arrLength varchar(10),showColumn varchar(200),dataArr varchar(2000),colArr varchar(2000),displayfield varchar(200),separatedst varchar(10),refCol varchar(2000))
AS
begininsert into @table  values ('1', '1', '1', '1', '1', '1','1','1')
return
end创建上面的函数后，我运行下面的代码就会报错。
select * from _sys_getTreeSQL(10002)错误提示：
服务器: 消息 170，级别 15，状态 1，行 1
第 1 行: '' 附近有语法错误。这是怎么回事？

Answer 1

select * from dbo._sys_getTreeSQL(10002)表值函数可以不用加DBO.的,奇怪?

Answer 2

create function _sys_getTreeSQL (@formID int)
returns @table table(treeSQL varchar(1500),arrLength varchar(10),showColumn varchar(200)
,dataArr varchar(2000),colArr varchar(2000),displayfield varchar(200),separatedst varchar(10),refCol varchar(2000))
AS
begininsert into @table values ('1', '1', '1', '1', '1', '1','1','1')
return
end
select * from dbo._sys_getTreeSQL(1)treeSQL                                                                                                                                                                                                                                                          arrLength  showColumn                                                                                                                                                                                               dataArr                                                                                                                                                                                                                                                          colArr                                                                                                                                                                                                                                                           displayfield                                                                                                                                                                                             separatedst refCol
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1                                                                                                                                                                                                                                                                1          1                                                                                                                                                                                                        1                                                                                                                                                                                                                                                                1                                                                                                                                                                                                                                                                1                                                                                                                                                                                                        1           1(1 行受影响)

Answer 3

代码没问题啊 alter function _sys_getTreeSQL (@formID int)
returns @table table
(
treeSQL varchar(1500),
arrLength varchar(10),
showColumn varchar(200),
dataArr varchar(2000),
colArr varchar(2000),
displayfield varchar(200),
separatedst varchar(10),
refCol varchar(2000)
)
AS
begin
insert into @table values ('1', '1', '1', '1', '1', '1','1','1')
return
end
select * from _sys_getTreeSQL(10002)

Answer 4

知道了，SELECT前面有个全角空格

Answer 5

alter function _sys_getTreeSQL (@formID int)
returns @table table(
treeSQL varchar(1500),
arrLength varchar(10),
showColumn varchar(200),
dataArr varchar(2000),
colArr varchar(2000),
displayfield varchar(200),
separatedst varchar(10),
refCol varchar(2000))
AS
begin
insert into @table values ('1','1','1','1','1','1','1','1')
return
end
GO
SELECT * FROM _sys_getTreeSQL(10002)这个OK

Answer 6

htl258，感谢呀，搞了好久，观察入微，可能是我用eclipse的原因。