want to start programming in sql

Lex · 13 Jul 2006 at 10:55

basically i want to start programming in sql. I've done a little research and am currently downloading:

- .net framework sp1 (although i got sp2 running on pc)
- sql server express 2005

is this all i need to start programming in sql? I want to have the front end of my programming in ASP however i think i need visual studio express 2005. Is that correct?

have i got the right setup? Where is it that i write the code? as this seems to be sql server i dont see an option to write the code and compile.

Lex · 13 Jul 2006 at 12:52

Dj_Jestar said:
You don't program in SQL Server as such, as it is a Database and that's it

You can 'program' stored procedures etc, but they are basic in comparison to application programming (web-app or desktop app)

ASP is what you'll actually 'program' with, that will be where the application logic resides. All SQL allows you to do, is manipulate and retrive data from the Database.

For ASP tutorials, google is your friend

So let me get this right. i dont have to program in sql i have to learn asp and that will connect to sql server whereby the data is retrieved. i dont understand. i want to learn both asp and sql but i thought i'd start with sql despite i do have some previous knowledge of it. does that mean i need to download visual studio?

Lex · 13 Jul 2006 at 14:04

Dj_Jestar said:
Visual Studio can be used to create ASP applications. (amongst other languages as well)

SQL is literally a command string.

Code:

SELECT * FROM `table` WHERE `column1` = '10'

is an example of SQL.

right so really its about learning asp. basically i want to publish my page my first 'hello world' page but im unsure of how to do so. i ensured microsoft IIS is running but i dont see no server wizard where i have to place the .asp homepage. any ideas?

Lex · 13 Jul 2006 at 14:13

Dj_Jestar said:
Yes, your IIS will be configred with a Document Root.

Typically this is the 'inetpub/wwwroot' directory, within the installation directory of IIS.

e.g.: C:/Program Files/IIS/inetpub/wwwroot/

yeh i got it but what do i do create a directory in wwwroot\myfirstsite\default.asp <<<<is this what i need to create? if so then what?sorry for the questions but once i get this sorted i can start learning the coding.

Lex · 13 Jul 2006 at 14:21

Dj_Jestar said:
Browse to the page in your Internet Browser:

http://localhost/myfirstsite/default.asp

veeery cool. it works. so now i got to start learning how to use visual studio. i dont know exactly what i accomplished. is it that now i can test out my pages based on *** coding that i write. iim going to write my code in asp? then copy and paste them into 'myfirstsite' and watch my creation?

Lex · 13 Jul 2006 at 14:46

Dj_Jestar said:
Yup.

Welcome to the world of programming

dont suppose you got any recommended asp books (online [free]) ?????

Lex · 13 Jul 2006 at 15:08

happytechie said:
try the following:

http://msdn.microsoft.com
www.gotdotnet.com
www.dotnetjunkies.com

all have links to ASP.net tutorials.

HT

thank you buddy.

Lex · 13 Jul 2006 at 16:31

Lex said:
thank you buddy.

the programmer at the office just showed me some amazing stuff in relation to asp and sql.

i'm inspired officially! he's a genie been programming for 10yrs. can only imagine he's on looooads of money considering that he's created the system that we use within the office and maintaining it