Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
lassise
Starting Member
8 Posts |
Posted - 2012-12-04 : 21:15:26
|
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
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-04 : 21:19:24
|
I guess you can download evaluation edition for SQL which is free and start learning from there. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-12-05 : 06:53:47
|
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. |
|
|
lassise
Starting Member
8 Posts |
Posted - 2012-12-05 : 10:14:39
|
Thanks sunitabeck, I now have a place to put the code, but how do I see an output? What do I attach it to? |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-12-05 : 10:18:24
|
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 |
|
|
lassise
Starting Member
8 Posts |
Posted - 2012-12-05 : 17:01:47
|
Thanks for the help, I have it figured out |
|
|
|
|
|
|
|