使用SQL Azure 的BI 解决方案
2012-09-18 13:35:57 来源：WEB开发网核心提示：[StoreName][nvarchar](50)NULL,[StoreRegion][nvarchar](50)NOT NULL,[StoreFY08Sales][nvarchar](50)NOT NULL,[StoreFY09Sales][nvarchar](50)NULL,[StoreFY10Sales][nva
[StoreName][nvarchar](50)NULL,
[StoreRegion][nvarchar](50)NOT NULL,
[StoreFY08Sales][nvarchar](50)NOT NULL,
[StoreFY09Sales][nvarchar](50)NULL,
[StoreFY10Sales][nvarchar](30)NULL,
[StoreFY11Sales][nvarchar](30)NULL,
[Timestamp][timestamp] NOT NULL
)
现在有了表StoreSales，打算在这个表中填入一些数据。为此，创建另一个SQL 脚本
来在其中加入几条记录。
(10) 单击New Query 按钮，在Query 窗口中输入下面的脚本，这会在StoreSales 表中
创建一组新的记录。
INSERTINTO [StoreSales]
([StoreName],[StoreRegion],[StoreFY08Sales],[StoreFY09Sales],[StoreFY10
Sales],[StoreFY11Sales])
VALUES
('SeattleDowntown', 'Pac West','12091029','13092802','13291028','14291820'),
('RedmondEastside','Pac West', '32039201','32991821','32003910','33210921'),
('NewYork Upstate', 'North East','22120928','22291092','23309211','23430291'),
('BostonEastgate','North East', '13000902','13445702','13220882','13233211'),
('SanDiego Downtown', 'South West','15561029','16772802','15441028','14981820'),
('OaklandBay','South West', '23043102','23332102','23443192','23998291'),
('OrlandoUniversal', 'South East','31093329','33111802','33295428','34291220'),
('MinnesotaEarling','Mid West', '13099002','13443102','13229972','13946591'),
('OhioState', 'Mid West','12091029','22093302','22291228','22294420'),
('ChicagoMain','Mid West', '33222102','33213102','33223192','33433291'),
('WestVirginia', 'Mid East','14121029','14332802','14121028','14998820'),
('NewOrleans Central','South East', '15011103','15291302','15224092','15221291'),
('JacksonvilleVilla', 'South East','23231029','23000902','23291029','24299288'),
('PortlandDowntown','Pac West', '15220102','15298112','15223302','15332292'),
('SanFrancisco Bay', 'South West','12091029','13092802','13291028','14291820'),
('BellinghamNorth','Pac West', '10112102','1022202','10220121','10993311'),
('HoustonMain', 'Central','12091029','13033202','13112128','14432820'),
('VancouverSouth WA','Pac West', '16654102','16755102','16344192','16332291'),
('KansasCity Downtown','Mid West', '22392012','22302910','23302903','23403920'),
('LosAngeles West', 'South West','12998098','12899878','12998190','13201920'),
('RedwoodSouth','South West', '20029102','20123321','21221092','21221998'),
- ››sql server自动生成批量执行SQL脚本的批处理
- ››使用linux中的quota教程
- ››sql server 2008亿万数据性能优化
- ››SQL Server 2008清空数据库日志方法
- ››sqlserver安装和简单的使用
- ››SQL Sever 2008 R2 数据库管理
- ››使用jxl生成带动态折线图的excel
- ››SQL SERVER无法安装成功，sqlstp.log文件提示[未发...
- ››Sql Server中通过父记录查找出所有关联的子记录
- ››SqlServer触发器、存储过程和函数
- ››SQL Server 中的事务(含义,属性,管理)
- ››Sqlite数据库插入和读取图片数据
中查找“使用SQL Azure 的BI 解决方案”更多相关内容
中查找“使用SQL Azure 的BI 解决方案”更多相关内容更多精彩
赞助商链接
