SQL语法系列三

1、

---通用表表达式CTEwith cteas(   select *  from dbo.LbtProjectInfo)select ID,ProjectName,ContractNumber  from  cte-----通用表表达式CTE-----连接查询with  ProjectCte(ID,ProjectName,ContractNumber)as(   SELECT  ID,ProjectName,ContractNumber  from LbtProjectInfo)SELECT  c.id,c.htmc,c.xmbh  FROM ContractRview c inner join  ProjectCte ct   on c.xmbh=ct.ContractNumber  order by ct.ID

相关文档：http://www.cnblogs.com/libingql/p/4461715.html

=============================

----sqlserver查询当前库下，一张表的表名，字段名，字段类型，字段长度select a.name LbtProjectInfo,b.name 字段名,c.name 字段类型,c.length 字段长度 from sysobjects a,syscolumns b,systypes c where a.id=b.idand a.name='LbtProjectInfo' and a.xtype='U'and b.xtype=c.xtype