大侠帮忙--使用with怎么报错

[andy796746]

with testtab(studentID,stuName,courseID,score)
as
(
select s.S#,sname,C#,score from student s left outer join sc on sc.S#=s.S#
)
select studentID,stuName,courseID,score from testtab

消息 156，级别 15，状态 1，第 1 行
在关键字 'with' 附近有语法错误。

[水族杰纶]

你用的2000吗

[中国风]

;with testtab(studentID,stuName,courseID,score)
as
(
select s.S#,sname,C#,score from student s left outer join sc on sc.S#=s.S#
)
select studentID,stuName,courseID,score from testtab

--CTE前有語句時加上分號";"

[andy796746]

[Quote=引用 1 楼 wufeng4552 的回复:]
你用的2000吗
[/Quote]我用的是2005

[andy796746]

[Quote=引用 2 楼 roy_88 的回复:]
;with testtab(studentID,stuName,courseID,score)
as
(
select s.S#,sname,C#,score from student s left outer join sc on sc.S#=s.S#
)
select studentID,stuName,courseID,score from testtab

--CTE前有語句……
[/Quote]没有句子啊

[claro]

with testtab (a,b,c,d)
as 
(
select 1 a,2 b,3 c,4 d union all select 11,12,13,14 
)
select a,b,c,d from testtab

--result:
a           b           c           d
----------- ----------- ----------- -----------
1           2           3           4
11          12          13          14

(2 行受影响)

[修改一下昵称]

select s.S#,sname,C#,score from student s left outer join sc on sc.S#=s.S#


你先单独执行这条语句能否通过！！！

[winstonbonaparte]

with在SQL2005裏是做什麼用的？

[「已注销」]

应该是你“select s.S#,sname,C#,score from student s left outer join sc on sc.S#=s.S#”有问题。

;with testtab (a,b,c,d)
as 
(
select 1 a,2 b,3 c,4 d  
)
select a,b,c,d from testtab

a           b           c           d
----------- ----------- ----------- -----------
1           2           3           4

(1 row(s) affected)

[「已注销」]

[Quote=引用 7 楼 winstonbonaparte 的回复:]

with在SQL2005裏是做什麼用的？
[/Quote]
递归~