Transact-SQL 参考

titles

Column_name 数据类型 可为空 默认值 检查 键/索引
title_id tid 聚集主键
title varchar(80) 非聚集
type char(12) 'UNDECIDED'
pub_id char(4) 外键 publishers (pub_id)
price money  
advance money
royalty int  
ytd_sales int
notes varchar(200)
pubdate datetime GETDATE( )

  

这些表显示 titles 表的内容。第一列 (title_id) 在后两个表中重复出现,后两个表中分别还包括第 6 列到第 8 列、第 9 列到第 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 "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