Question

数据库SQL创建存储过程显示“.”附近有语法错误，谁能告诉我哪错了。。。

CREATE PROCEDURE news_select_lmid
@lmid int
as
SELECT 新闻.nwid, 新闻.lmid, 新闻.标题, 新闻.时间, 栏目.栏目
FROM 栏目INNER JOIN
新闻ON 栏目.lmid = 新闻.lmid
where 新闻.lmid = @lmid
order by 时间desc
return

Answer 1

CREATE PROCEDURE news_select_lmid
@lmid int
as
SELECT [新闻].nwid, [新闻].lmid, [新闻].[标题], [新闻].[时间], [栏目].[栏目]
FROM [栏目]INNER JOIN
[新闻]ON [栏目].lmid = [新闻].lmid
where [新闻].lmid = @lmid
order by [时间]desc
return