you can refer http://w3schools.com this is a best site for starters

http://w3schools.com/asp/asp_ado.asp -- for ASP
http://w3schools.com/ado/default.asp -- for ADO
http://w3schools.com/sql/default.asp -- for SQL


M.V.Kishore Reddy

Hi

my requirement is like this - I need to maintain a subscription DB with more then 30 million rows in sql server thet keeps on increasing. I need to Update ,Insert and select from the Table. Problem is this has to be integrated with existing application where performance should not get effected. In this table application id and user number are unique.

Can anyone suggest what should be the approach.with minimum effect...