id: 11792    nodeId: 11792    type: General    point: 125.0    linkPoint: 1.0    maker: cella    permission: linkable    made at: 2013.07.09 05:36    edited at: 2013.07.09 05:36
MS SQL installation on Windows XP
There are versions of SQL 2005, 2008, 2008 r2, 2012.
For each version, there are editions of express, standard, developer, enterprise, each of which has 32-bit and 64-bit variations.

For Windows XP pro, enterprise edition cannot be installed.

SQL 2008 standard r2 requires 5.6 GB when full-installed.
SQL 2005 developer requires (maybe) about 1 GB when full-installed.

When the SQL server is used standalone, the port, user account, or other configuration details need not be addressed.


- importing .mdf file. Note that a .mdf file can have zero or more .ndf files and one .ldf file.
SQL Server Management Studio > 개체탐색기 > right-click on 데이타베이스 > 연결 > 추가

- query transaction
SQL Server Management Studio > 개체탐색기 > right-click on the particular db > 새 쿼리 > 쿼리 입력 > 실행 (on menu bar)
example query: select SCALE_MAX from MULTI_VALUE_DATA where TIME_STAMT between '2012-09-18 09:00:00' and '2012-09-18 10:00:00'

- saving the query result
right click on the field bar of the query result > 다른 이름으로 결과 저장 > default outpuf file format is of .csv excel file


Return to MS Windows 8 에서 sleep, hibernate or MS SQL installation on Windows XP