SQL to Web

[Ihecky]

Hi, I am fairly new to SQL Administration, and my question today is how to access SQL DBs through a Web Page.
I don't expect the full answer obviously, but some references or starting pointers would help.

Thank you

 

[skitter]

Check IIS from microsoft. You have several examples in the help file (accessible from the default homepage).

 

[SQLSister]

You can use any of the standard web programming languages to call data from SQL server (except HTML of course!). We use ASP.Net, ADO.Net and XML here.

We do not allow the programmers to write any SQL statements in their web code. All are called from stored procedures. There are several reasons for this. First is performance. Second is the ability of the dba personnel to review/control the way the data is accessed. It also keeps them from writing unneed cursors.

 

[litenin]

You could also have a look at sp_makewebtask in the BOL. It probably doesn't do what you want but I've found it useful for creating status pages for data warehouse overnight tasks etc.

Thanks

Dave