| Author |
 Topic  |
|
|
lassise
Starting Member
USA
8 Posts |
 Posted - 12/04/2012 : 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
Flowing Fount of Yak Knowledge
USA
7173 Posts |
Posted - 12/04/2012 : 21:19:24
|
| I guess you can download evaluation edition for SQL which is free and start learning from there. |
 |
|
|
sunitabeck
Flowing Fount of Yak Knowledge
5152 Posts |
Posted - 12/05/2012 : 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
USA
8 Posts |
Posted - 12/05/2012 : 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
Flowing Fount of Yak Knowledge
5152 Posts |
Posted - 12/05/2012 : 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
USA
8 Posts |
Posted - 12/05/2012 : 17:01:47
|
| Thanks for the help, I have it figured out |
|
|
| |
Topic |
|
Where to begin?!
