Transact-SQL Reference
titles
| Column_name | Data type | Nullable | Default | Check | Key/index |
|---|---|---|---|---|---|
| title_id | tid | no | PK, clust. | ||
| title | varchar(80) | no | Nonclust. | ||
| type | char(12) | no | 'UNDECIDED' | ||
| pub_id | char(4) | yes | FK publishers (pub_id) | ||
| price | money | yes | |||
| advance | money | yes | |||
| royalty | int | yes | |||
| ytd_sales | int | yes | |||
| notes | varchar(200) | yes | |||
| pubdate | datetime | no | GETDATE( ) |
These tables show the contents of the titles table. The first column (title_id) is repeated in the tables that follow, along with columns 6 through 8, and 9
through 10.
| title_id (1) | title (2) | type (3) | pub_id (4) | price (5) |
|---|---|---|---|---|
| BU1032 | The Busy Executive's Database Guide | business | 1389 | 19.99 |
| BU1111 | Cooking with Computers: Surreptitious Balance Sheets | business | 1389 | 11.95 |
| BU2075 | You Can Combat Computer Stress! | business | 0736 | 2.99 |
| BU7832 | Straight Talk About Computers | business | 1389 | 19.99 |
| MC2222 | Silicon Valley Gastronomic Treats | mod_cook | 0877 | 19.99 |
| MC3021 | The Gourmet Microwave | mod_cook | 0877 | 2.99 |
| MC3026 | The Psychology of Computer Cooking | UNDECIDED | 0877 | NULL |
| PC1035 | But Is It User Friendly? | popular_comp | 1389 | 22.95 |
| PC8888 | Secrets of Silicon Valley | popular_comp | 1389 | 20.00 |
| PC9999 | Net Etiquette | popular_comp | 1389 | NULL |
| PS1372 | Computer Phobic and Non-Phobic Individuals: Behavior Variations | psychology | 0877 | 21.59 |
| PS2091 | Is Anger the Enemy? | psychology | 0736 | 10.95 |
| PS2106 | Life Without Fear | psychology | 0736 | 7.00 |
| PS3333 | Prolonged Data Deprivation: Four Case Studies | psychology | 0736 | 19.99 |
| PS7777 | Emotional Security: A New Algorithm | psychology | 0736 | 7.99 |
| TC3218 | Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean | trad_cook | 0877 | 20.95 |
| TC4203 | Fifty Years in Buckingham Palace Kitchens | trad_cook | 0877 | 11.95 |
| TC7777 | Sushi, Anyone? | trad_cook | 0877 | 14.99 |
| title_id (1) | advance (6) | royalty (7) | ytd_sales (8) |
|---|---|---|---|
| BU1032 | 5,000.00 | 10 | 4095 |
| BU1111 | 5,000.00 | 10 | 3876 |
| BU2075 | 10,125.00 | 24 | 18722 |
| BU7832 | 5,000.00 | 10 | 4095 |
| MC2222 | 0.00 | 12 | 2032 |
| MC3021 | 15,000.00 | 24 | 22246 |
| MC3026 | NULL | NULL | NULL |
| PC1035 | 7,000.00 | 16 | 8780 |
| PC8888 | 8,000.00 | 10 | 4095 |
| PC9999 | NULL | NULL | NULL |
| PS1372 | 7,000.00 | 10 | 375 |
| PS2091 | 2,275.00 | 12 | 2045 |
| PS2106 | 6,000.00 | 10 | 111 |
| PS3333 | 2,000.00 | 10 | 4072 |
| PS7777 | 4,000.00 | 10 | 3336 |
| TC3218 | 7,000.00 | 10 | 375 |
| TC4203 | 4,000.00 | 14 | 15096 |
| TC7777 | 8,000.00 | 10 | 4095 |
| title_id (1) | notes (9) | pubdate (10) |
|---|---|---|
| BU1032 | An overview of available database systems with emphasis on common business applications. Illustrated. | Jun 12 1991 12:00AM |
| BU1111 | Helpful hints on how to use your electronic resources to the best advantage. | Jun 9 1991 12:00AM |
| BU2075 | The latest medical and psychological techniques for living with the electronic office. Easy-to-understand explanations. | Jun 30 1991 12:00AM |
| BU7832 | Annotated analysis of what computers can do for you: a no-hype guide for the critical user. | Jun 22 1991 12:00AM |
| MC2222 | Favorite recipes for quick, easy, and elegant meals. | Jun 9 1991 12:00AM |
| MC3021 | Traditional French gourmet recipes adapted for modern microwave cooking. | Jun 18 1991 12:00AM |
| MC3026 | NULL | Apr 28 1995 10:36AM |
| PC1035 | A survey of software for the naive user, focusing on the "friendliness" of each. | Jun 30 1991 12:00AM |
| PC8888 | Muckraking reporting on the world's largest computer hardware and software manufacturers. | Jun 12 1994 12:00AM |
| PC9999 | A must-read for computer conferencing. | Apr 28 1995 10:36AM |
| PS1372 | A must for the specialist, examining the difference between those who hate and fear computers and those who don't. | Oct 21 1991 12:00AM |
| PS2091 | Carefully researched study of the effects of strong emotions on the body. Metabolic charts included. | Jun 15 1991 12:00AM |
| PS2106 | New exercise, meditation, and nutritional techniques that can reduce the shock of daily interactions. Popular audience. Sample menus included, exercise video available separately. | Oct 5 1991 12:00AM |
| PS3333 | What happens when the data runs dry? Searching evaluations of information-shortage effects. | Jun 12 1991 12:00AM |
| PS7777 | Protecting yourself and your loved ones from undue emotional stress in the modern world. Use of computer and nutritional aids emphasized. | Jun 12 1991 12:00AM |
| TC3218 | Profusely illustrated in color, this makes a wonderful gift book for a cuisine-oriented friend. | Oct 21 1991 12:00AM |
| TC4203 | More anecdotes from the Queen's favorite cook describing life among English royalty. Recipes, techniques, tender vignettes. | Jun 12 1991 12:00AM |
| TC7777 | Detailed instructions on how to make authentic Japanese sushi in your spare time. | Jun 12 1991 12:00AM |