What 2 componenets are needed to write an SQL statement?
November 5, 2009 - 11:12 pm
How do you sum the columns
Main are
Step 1: Loading Drivers
Step 2: Making a Connection
Step 3: Creating JDBC Statements
Step 4: Executing the Statement
Step 5: Looping Through the ResultSet
Step 6: Closing the Connection and Statement Objects
For details of each step go to this link
http://www.developer.com/db/article.php/942641
November 6th, 2009 at 4:25 am
Main are
Step 1: Loading Drivers
Step 2: Making a Connection
Step 3: Creating JDBC Statements
Step 4: Executing the Statement
Step 5: Looping Through the ResultSet
Step 6: Closing the Connection and Statement Objects
For details of each step go to this link
http://www.developer.com/db/article.php/942641
References :
November 6th, 2009 at 4:49 am
1) Verb clause: SELECT/INSERT/UPDATE/DELETE
2) FROM clause
Everything else is optional
References :
November 6th, 2009 at 5:26 am
Hmmm, I’m thinking you need 1) a verb for the action that you want, such as SELECT, INSERT, UPDATE, or DELETE, etc. and then 2) the database table name to act upon.
References :
November 6th, 2009 at 5:41 am
for viewing data use the SELECT from clause along with a table or viewname. u can retsrict results using the WHERE or HAVING clause, arrange results using GROUP BY or ORDER BY clause.
use INSERT INTO table VALUES( comma separated list of values)
to insert data.
use the DELETE clause to delete data
and use UPDATE table SET column=value clause to update data.
here u can also refer a row or rows using the WHERE clause or the HAVING clause (which is used with the GROUP BY clause
use CREATE , ALTER or DROP clauses to add , change or remove database objects
References :
msdn2.microsoft.com
November 6th, 2009 at 6:14 am
INSERT, UPDATE, or DELETE or a connection to a DB
References :
November 6th, 2009 at 6:20 am
1. DBMS
2. Client Tools.
Additional details:
+
References :