I would like to make a database and start teaching myself T-SQL. What do I need to download?

Question

I have a desktop running Microsoft Windows Vista, Home Premium. I would like to use either MS SQL 2005, or the 2008 CTP. It doesn't really matter to me. What I need to know is everything I need to download (links would be great) and install in order to be able to create a few files, and start coding some Transact SQL statements.

Can this be done on a stand-alone desktop system? Do I need "Management Studio"? What version? Do I need some kind of a .net framework download? Visual Studio? (I'm sorry, I really don't know much about this and am REALLY counting on the kindness of strangers to get me started.)

Thank you so much for taking the time to carefully answer.

Answer 1

Download SQL Server 2005 Express (easy to find)

Download SQL Server Management Studio Express

http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en



If you don't already have the required version of .Net Framework it will be installed with SQL Server.

Answer 2

Follow the steps listed here: http://www.mydigitallife.info/2007/10/31/error-has-occurred-while-establishing-a-connection-to-sql-server-2005-which-does-not-allow-local-and-remote-connections/



I've had this exact problem... on some machines I've been able to resolve it, on other's I haven't. I do know that the steps listed in the above link can solve the problem though

Answer 3

classes dont teach you a programming language. I propose which you get a e book on sq.. the perfect thank you to start is via making an uncomplicated database using MySQL (unfastened). there are thousands of tutorials on the internet on a thank you to attain this and the syntax incredibly isnt that annoying.