SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Where to begin?!
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lassise
Starting Member

USA
8 Posts

Posted - 12/04/2012 :  21:15:26  Show Profile  Reply with Quote
I learned SQL in college 3 years ago, and I am currently working on a project at my house that requires a members database & collection of DVD's db, as well as one for the directors. The coding isn't the problems so much as I can't figure out how to start? I don't own a SQL server or anything like that. Is there a program, or even like notepad++ where I can create tables in SQL and debug/execute queries? I can't seem to find it in VS Express. I am only supposed to be using classic ASP, ADO, and SQL.

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 12/04/2012 :  21:19:24  Show Profile  Reply with Quote
I guess you can download evaluation edition for SQL which is free and start learning from there.
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 12/05/2012 :  06:53:47  Show Profile  Reply with Quote
Alternatively, download SQL 2012 Express with Tools from here - it is free to download and use: http://www.microsoft.com/en-us/download/details.aspx?id=29062

It includes SQL Server Management Studio that will let you interact with the server to create databases, tables, procedures etc.
Go to Top of Page

lassise
Starting Member

USA
8 Posts

Posted - 12/05/2012 :  10:14:39  Show Profile  Reply with Quote
Thanks sunitabeck, I now have a place to put the code, but how do I see an output? What do I attach it to?
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 12/05/2012 :  10:18:24  Show Profile  Reply with Quote
If you installed that package, you will have a SQL Sever installed on your computer. To connect to that server, use the name (local)\SqlExpress for servername in the login dialog. Once you connect to that server, you can run queries against it. This tutorial may help: http://msdn.microsoft.com/en-us/library/bb934498(v=sql.105).aspx
Go to Top of Page

lassise
Starting Member

USA
8 Posts

Posted - 12/05/2012 :  17:01:47  Show Profile  Reply with Quote
Thanks for the help, I have it figured out
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000