在SQL2005/SQL2008中CTE用法差异

--SQL2008中执行成功

SELECT @@version 
/*
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Data Center Edition (64-bit) on Windows NT 6.1  (Build 7600: ) (Hypervisor) 
*/
IF 1>0WITH cAS(SELECT 1 AS ID)SELECT * FROM c

--SQL2005中执行相同语句时出错

SELECT @@VERSION
/*
Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86)   Dec 10 2010 10:56:29   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 6.1 (Build 7600: ) 
*/IF 1>0WITH cAS(SELECT 1 AS ID)SELECT * FROM c
/*
消息 319，级别 15，状态 1，第 2 行
关键字 'with' 附近有语法错误。如果此语句是公用表表达式或 xmlnamespaces 子句，那么前一个语句必须以分号结尾。*/--改为
IF 1>0
BEGINWITH cAS(SELECT 1 AS ID)SELECT * FROM c
END