By commenting, you are accepting the IBM commenting guidelines and the DISQUS terms of service.
(AP Photo/Kristen Gelineau) Trump, Lebanese leader pledge solidarity against terrorism Official: Driver in smuggling attempt part of larger group The Latest: Capitol Police arrest 95 in demonstrations The Latest: Haley urges UN to get serious about Hezbollah MELBOURNE, Australia (AP) — The most senior Vatican official ever charged in the Catholic Church sex abuse crisis made his first court appearance in Australia on Wednesday in a scandal that has stunned the Holy See and threatened to tarnish the pope's image as a crusader against abusive clergy.
For example, if more than one person in your family keeps pets, you might want to list each animal's owner.
You might also want to record some basic descriptive information such as species and sex. That might be of interest, but it is not a good thing to store in a database.
Following the same scheme as with the first post of this series, here is the code for creating 2 similar tables with CREATE TABLE dbo.
Char Test Table NN ( id INT IDENTITY NOT NULL PRIMARY KEY, client_name CHAR(20) NOT NULL DEFAULT 'Super Client', sex CHAR(1) NOT NULL DEFAULT 'M', confirmation CHAR(1) NOT NULL DEFAULT 'N', state_code CHAR(2) NOT NULL DEFAULT 'WA', some_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, some_amount DECIMAL(9,2) NOT NULL DEFAULT 128.34, ); CREATE TABLE dbo.
Then, whenever you need age, you can calculate it as the difference between the current date and the birth date.