In this discussion, we’ll explore the update statement and take look at the where clause. The Update statement is used for updating values in a cell/cells of a table. It is commonly used on tables that already exist in the database , temporary tables or table variables. We’ll take look at table variables later in […]
In this lesson, l’m going to explore 3 statements that might sound similar but are different in how they work. The first statement is the Delete statement. Delete is used for removing records in a table or objects. If the delete statement is issued without a Where Clause, all records in the specified table will be […]
In this lesson, we’ll explore the select statement. The select statement is used mostly for reading data from objects in the database. Let’s create a table, insert data into it and display the data using the select statement. —Creating the table CREATE TABLE student (sid int primary key, firstname varchar(50), lastname varchar (50) ) –Adding […]
In this discussion, we’ll explore different ways records can be added to a table using the insert statement. The insert statement is the only statement that actually populates table with a record. Now, we saw the various constraints that can be imposed on a table in tutorial 1. This constraints must be obeyed when inserting […]