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