want to start programming in sql

Lex

Lex

Lex

Associate
Joined
26 Dec 2002
Posts
971
Location
NW London, United Kingdom
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.
 
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 :)
 
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 :)
Click to expand...

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?
 
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.
 
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.
Click to expand...

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?
 
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/
 
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/
Click to expand...

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.
 
Dj_Jestar said:
Browse to the page in your Internet Browser:

http://localhost/myfirstsite/default.asp
Click to expand...


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?
 
Just to be pedantic, you can program stored procedures in .net now so technically the whole core code can sit inside SQL Server.

Not at all advisable, just being obnoxious!
 
it not bad actually we put quite a lot of buisness logic into the database as stored precedures written in C#.

They are WAY faster than the same algorithms stored as normal C# code in DLLs on the web tier. I think it's to do with having them actually located on (all) of the database servers in a federated cluster rather than on the web tier. and having to connect to the DB over TCP/IP

HT
 
Lex said:
thank you buddy.
Click to expand...


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
 
Gotta also add my chip in here, been progamming SQL for almost 10 years now and aprt from dBase III+, is my fave language.

Not only can you program stored procedures to do a whole myriad of updates or bring back data how you want AND perform calculations on the server rather than in your code, but of course using a DTS package and converting this to a "Job", you can even have your programs running outside of normal working hours so calculations are still been performed without the need of any user input!

SQL rocks! And SQL2005 is almost a full language in itself!
 
Indeed, SQL linked up with DTS and Stored procedures can do some wonderful things.

We have all our business information running overnight through scheduled DTS's then use JP graphs within PHP to present the peformance directly to the teams.

Wonderful Stuff :D
 
happytechie said:
it not bad actually we put quite a lot of buisness logic into the database as stored precedures written in C#.

They are WAY faster than the same algorithms stored as normal C# code in DLLs on the web tier. I think it's to do with having them actually located on (all) of the database servers in a federated cluster rather than on the web tier. and having to connect to the DB over TCP/IP

HT
Click to expand...

That is true and at the same time not true. I was a DBA in a past life and the thought of running developers code with no way of knowing what it's doing under MY SQL Server process, using MY memory buffer scared the holy be-jesus out of me. We're a very conservative lot us DBAs, good job I'm not one anymore eh?
 
You must log in or register to reply here.
Back
Top Bottom