--復(fù)制表結(jié)構(gòu)

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

--列數(shù)數(shù)據(jù)庫所有的表名
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

--內(nèi)外鏈接

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