Sample Project Data

Data used for the sample projects are contained within a table called db_employee. The table has three columns, as follows:

Table 1 Sample Project Data - db_employee Table

Column Name	Data Type	Data Length
emp_no	INTEGER	10
last_name	VARCHAR	30
first_name	VARCHAR	30
rate	FLOAT	15
last_update	TIMESTAMP	19

---

Note –

SQL Server databases do not accept table data with columns that include Boolean data types. For example, an SQL Server server expects a literal “T” or “F” for True or False Boolean values, and does not accept Java primitive Boolean True or False values.

---