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 […]
I’ve been discussing general information about database/sql development but l’m now going to concentrate on one flavour of SQL called TSQL, microsoft version of SQL. TSQL is used by all microsoft SQL servers, so knowing TSQL in general will allow you to program in all microsoft SQL servers with minimal changes. I’m going to base […]