27,581
社区成员
发帖
与我相关
我的任务
分享创建视图出错，请指教？？
CREATE VIEW dbo.MenuView
AS
SELECT t1.MenuId, t1.MenuCaption, t1.MenuParent, t2.MenuCaption AS MenuParentCaption
FROM dbo.MenuInfo t1 LEFT OUTER JOIN
dbo.MenuInfo t2 ON t1.MenuParent = t2.MenuId
WHERE (t1.MenuId <> t1.MenuParent)
SET QUOTED_IDENTIFIER OFF
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
提示:'CREATE VIEW' 必须是批查询中的第一条语句。这是什么意思呀?怎么解决??
...全文
请发表友善的回复…
发表回复
marco08 2006-06-28
- 打赏
- 举报
GO
GO
GO
GO
GO
78984598 2006-06-28
- 打赏
- 举报
视图间加GO
paoluo 2006-06-28
- 打赏
- 举报
每個視圖創建完成後加上一個GO
Create View V1
As
...
GO
Create View V2
As
...
GO
Create View V1
As
...
GO
Create View V2
As
...
GO
yinxj2006 2006-06-28
- 打赏
- 举报
当我同时创建多个视图时才出现那个提示？？那是怎么回事呀？？
hyrongg 2006-06-28
- 打赏
- 举报
CREATE VIEW dbo.MenuView
AS
SELECT t1.MenuId, t1.MenuCaption, t1.MenuParent, t2.MenuCaption AS MenuParentCaption
FROM dbo.MenuInfo t1 LEFT OUTER JOIN
dbo.MenuInfo t2 ON t1.MenuParent = t2.MenuId
WHERE (t1.MenuId <> t1.MenuParent)
GO
AS
SELECT t1.MenuId, t1.MenuCaption, t1.MenuParent, t2.MenuCaption AS MenuParentCaption
FROM dbo.MenuInfo t1 LEFT OUTER JOIN
dbo.MenuInfo t2 ON t1.MenuParent = t2.MenuId
WHERE (t1.MenuId <> t1.MenuParent)
GO
liangpei2008 2006-06-28
- 打赏
- 举报
--这样呢？
GO
CREATE VIEW dbo.MenuView
AS
SELECT t1.MenuId, t1.MenuCaption, t1.MenuParent, t2.MenuCaption AS MenuParentCaption
FROM dbo.MenuInfo t1 LEFT OUTER JOIN
dbo.MenuInfo t2 ON t1.MenuParent = t2.MenuId
WHERE (t1.MenuId <> t1.MenuParent)
SET QUOTED_IDENTIFIER OFF
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.MenuView
AS
SELECT t1.MenuId, t1.MenuCaption, t1.MenuParent, t2.MenuCaption AS MenuParentCaption
FROM dbo.MenuInfo t1 LEFT OUTER JOIN
dbo.MenuInfo t2 ON t1.MenuParent = t2.MenuId
WHERE (t1.MenuId <> t1.MenuParent)
SET QUOTED_IDENTIFIER OFF
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
