摘要：use test select * from sysobjects where xtype='u' select * from users truncate table users --删除所有记录，性能高于delete insert into users values(1,'admin') go insert into users values(2,'mrhu') go insert int... 阅读全文

摘要：http://pan.baidu.com/share/home?uk=4076915866#category/type=0 阅读全文

摘要：CREATE TABLE [dbo].[dim_date]( [Datekey] [int] NOT NULL, [FullDateAlternateKey] [date] NULL, [Year] [int] NULL, [Quarter] [int] NULL, [QuarterKey] [va 阅读全文