In this lesson, l want to briefly go over how to perform search using a wild card. The symbol used for wild card is the percent sign (%). Lets see how this is used to perform searches. Assume we have a table called person that has person id, first name and last name columns. Then […]
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 […]