Related:
- How to Store Data In Sql Server
- Where are database diagrams stored in sql server - Guide
- How to avoid duplicate data in sql query - Guide
- Convert string to date sql server dd/mm/yyyy - Guide
- How to delete facebook stored data - Guide
- Types of partitioning in sql server - Articles
2 replies
tommo2785
Jun 18, 2009 at 09:47 AM
- Posts
- 15
- Registration date
- Wednesday June 17, 2009
- Status
- Member
- Last seen
- June 19, 2009
Jun 18, 2009 at 09:47 AM
here is a link that shows examples on PHP
will give you the general format
http://www.webmasterworld.com/databases_sql_mysql/3011940.htm
still though check out w3schools they have good information easily explained covering all the basics. another place to look for questions others have already answered is SQLteam.com I also regularly go through there reading threads and learning more.
will give you the general format
http://www.webmasterworld.com/databases_sql_mysql/3011940.htm
still though check out w3schools they have good information easily explained covering all the basics. another place to look for questions others have already answered is SQLteam.com I also regularly go through there reading threads and learning more.
tommo2785
Jun 18, 2009 at 08:13 AM
- Posts
- 15
- Registration date
- Wednesday June 17, 2009
- Status
- Member
- Last seen
- June 19, 2009
Jun 18, 2009 at 08:13 AM
what exactly are you refering to? question about taking information off the form or question relating to the input of data into the DB/
If it is the former i cannot help as i have not learned that yet, however SQL language is Easy
INSERT INTO table_name
VALUES (value1, value2, value3,...);
INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...);
both those examples were plagiarized from w3schools. Really good information on here and easy to follow this was one of the sites i studied whilst doing Modules on Databases, helped me receive a 7 or high distinction.
they also have tutorials on ASP PHP CSS HTML etc. study that,and you will work out your own answer it is very easy working on database.
If your database is already functional with tables and relations correctly assigned and constrained with DDL the rest is easy, Designing a good EER DB is a fair bit mor challenging, hence why those guys are some of the best paid in the industry
If it is the former i cannot help as i have not learned that yet, however SQL language is Easy
INSERT INTO table_name
VALUES (value1, value2, value3,...);
INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...);
both those examples were plagiarized from w3schools. Really good information on here and easy to follow this was one of the sites i studied whilst doing Modules on Databases, helped me receive a 7 or high distinction.
they also have tutorials on ASP PHP CSS HTML etc. study that,and you will work out your own answer it is very easy working on database.
If your database is already functional with tables and relations correctly assigned and constrained with DDL the rest is easy, Designing a good EER DB is a fair bit mor challenging, hence why those guys are some of the best paid in the industry
Aug 4, 2009 at 05:47 AM
Well if u design asp page than for insrting data in sql server 2000 . u recquired to import namespaces sql.data and sq.data.client
after that u define object for sqlconnection.sqlcommand and sqldatareader
make a connection on page load.
and open that connection.
After making connection with server u have to fire sql query for insert values and pas the textbox values .
finally execute ommand executenonquery.