SQL：关键字附近的错误语法＆＃x27; select＆＃x27;

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

---

这个问题是由类错字或无法再现的问题引起的。虽然类似的问题可能是主题在这里，这一问题的解决方案的解决方案较小，无法帮助未来的读者。

闭合 2年前。

Answer 1

创建功能需要在单独的批处理中。只需添加一个 go ：

CREATE FUNCTION enrollment_no  (@enrollments INT)
RETURNS TABLE AS
RETURN
(   
 SELECT *
 FROM
 dbo.Users
 INNER JOIN
 dbo.Orders
 ON
 Users.Email = Orders.Email
 WHERE
 Enrollments = @enrollments
);

GO

SELECT *
FROM enrollment_no(4);