ASP : SQL Help Question!

 

You already have your asp enabled web space.

After setting up your SQL server on your web space you named it ‘GBOOKSQL’

 

Here is the question –

 

• How do you create new tables in ‘GBOOKSQL’
• How do you make ‘GBOOKSQL’ display and accept new records
• How do u edit and update records in ‘GBOOKSQL’
• How safe is ‘GBOOKSQL’
• And how fast is ‘GBOOKSQL’ because a SQL server is said to be larger than access db i.e. can take more data.

 

I will be grateful if you guys can help or still better if there’s a tutorial you can refer me to.

 

Thanks

Most of the axamples you'll find for administrating MSSQL will reference Enterprise Manager. There are alternatives though.

DbaMgr2K is a desktop app for admin'ing SQL Server. Need vb6 run time dll's - http://www.asql.biz/DbaMgr/DownLoad2k.shtm

TableEditoR is a handdy littl asp web application for doing the same. Also a neat little too for creating access db's quickly. - http://www.2enetworx.com/dev/projects/tableeditor.asp

There's also a couple of .net web apps around that'll tdo the same thing. A lot of hosts include them in your package.

w3schools.com is a good place to start with sql.