JAVA #32 – Java application using SQL server (Part: 03)

Submit Button Code

Show Button Code

   

JAVA #32 – Java application using SQL server (Part: 02)

Download both the files form here: Microsoft JDBC Driver 4.2 for SQL Server sqljdbc4-2.0.jar DBContext Class code:

   

SQL Server: 07 – INSERT and SELECT Statement

  INSERT Statement Syntax: INSERT INTO TABLE_NAME (column1, column2, column3,…columnN)] VALUES (value1, value2, value3,…valueN); SELECT Statement Syntax: SELECT column1, column2, columnN FROM table_name;  

   

SQL Server: 06 – ALTER and DROP Statement

ALTER Statement in SQL To add a column in a table, use the following syntax:

To delete a column in a table, use the following syntax: