CREATE FUNCTION NBR (@A VARCHAR(20)) RETURNS @t TABLE(col1 int,col2 varchar(20) ...) AS BEGIN insert @t SELECT * FROM SERV WHERE ACC_NBR=@A RETURN END
把BEGIN 和 END去掉试试CREATE FUNCTION NBR (@A VARCHAR(20)) RETURNS TABLE AS RETURN (SELECT * FROM SERV WHERE ACC_NBR=@A)
CREATE FUNCTION NBR(@A VARCHAR(20)) RETURNS TABLE AS --BEGIN RETURN (SELECT * FROM SERV WHERE ACC_NBR=@A) --END go select * from dbo.NBR('zs') drop FUNCTION NBR
RETURNS @t TABLE(col1 int,col2 varchar(20) ...)
AS
BEGIN
insert @t SELECT * FROM SERV WHERE ACC_NBR=@A
RETURN
END
RETURNS TABLE
AS
RETURN (SELECT * FROM SERV WHERE ACC_NBR=@A)
RETURNS TABLE
AS
--BEGIN
RETURN (SELECT * FROM SERV WHERE ACC_NBR=@A)
--END
go
select * from dbo.NBR('zs')
drop FUNCTION NBR