Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am looking to learn SQL server - specifically T-SQL programming, writing stored procedures etc and getting familiar.

I had a look at the MS site to download SQL Server express, however it gives me the below choices. Can someone please advise which should be the correct option considering my learning goal ?

  • SQL Server Express with Tools (with LocalDB, Includes the database engine and SQL Server Management Studio Express)
  • SQL Server Management Studio Express (Tools only)
  • SQL Server Express LocalDB (MSI installer)
  • SQL Server Express with Advanced Services (contains the database engine, Express Tools, Reporting Services, and Full Text Search)
  • SQL Server Express (Containing only the database engine)

These are present on below site -

http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx

share|improve this question
add comment

migrated from stackoverflow.com Jul 19 '12 at 6:33

This question came from our site for professional and enthusiast programmers.

2 Answers

I would go for:

SQL Server Express with Tools (with LocalDB, Includes the database engine and SQL Server Management Studio Express)

This gives you MS SQL Express and the Management Studio which will give you all the playground to experiment.

share|improve this answer
2  
Without question this is the version you want. It's a pain when you install without the Management Studio (when you end up needing it) –  northpole Jul 18 '12 at 14:43
    
Thanks for your help –  cherry Jul 18 '12 at 15:33
add comment

If your goal is to learn T-SQL programming then I would actually recommend SQL Server Data Tools. It comes with SQL Server Express LocalDB included, and it integrates with Visual Studio. The tool is focused on T-SQL development and is the best way of writing T-SQL procedures and other T-SQL code that will ship as part of an application.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.