Sql常用语句

 

--复制表结构

select * into News4 from News

select top 0 * into News3 from News

--拷贝表
insert into news2(Author, UpdateDate) select Author,UpdateDate from News
 

--查看视图
select * from (SELECT Id,Title,Author,Contents,UpdateDate FROM News) T where T.Id > 1

--列数数据库所有的表名
select name from sysobjects where type='U'

select type,sum(case vender when 'A' then pcs else 0 end),
sum(case vender when 'C' then pcs else 0 end),
sum(case vender when 'B' then pcs else 0 end)
FROM tablename group by type

--内外链接

select site.Name from Site right outer join Record on Site.Id=Record.SiteId