树结构图
TOP 10
  • 相关软件
    >titles　创建者：webmaster　更新时间：2006-02-16 15:51





































































































    Column_name数据类型可为空默认值检查键/索引
    title_idtid否 聚集主键
    titlevarchar(80)否 非聚集
    typechar(12)否'UNDECIDED'
    pub_idchar(4)是 外键 publishers (pub_id)
    pricemoney是  
    advancemoney是
    royaltyint是  
    ytd_salesint是
    notesvarchar(200)是
    pubdatedatetime否GETDATE( )



      



    这些表显示 titles 表的内容。第一列 (title_id) 在后两个表中重复出现，后两个表中分别还包括第 6 列到第 8 列、第 9 列到第 10 列。




























































































































































    title_id (1)title (2)type (3)pub_id (4)price (5)
    BU1032The Busy Executive's

    Database Guide    		business138919.99
    BU1111Cooking with Computers:Surreptitious Balance Sheetsbusiness138911.95
    BU2075You Can Combat

    Computer Stress!    		business07362.99
    BU7832Straight Talk About

    Computers    		business138919.99
    MC2222Silicon Valley Gastronomic

    Treats    		mod_cook087719.99
    MC3021The Gourmet Microwavemod_cook08772.99
    MC3026The Psychology of Computer CookingUNDECIDED0877NULL
    PC1035But Is It User Friendly?popular_comp138922.95
    PC8888Secrets of Silicon Valleypopular_comp138920.00
    PC9999Net Etiquettepopular_comp1389NULL
    PS1372Computer Phobic and

    Non-Phobic Individuals:Behavior Variations    		psychology087721.59
    PS2091Is Anger the Enemy?psychology073610.95
    PS2106Life Without Fearpsychology07367.00
    PS3333Prolonged Data Deprivation:Four Case Studiespsychology073619.99
    PS7777Emotional Security:A New Algorithmpsychology07367.99
    TC3218Onions, Leeks, and Garlic:Cooking Secrets of the

    Mediterranean    		trad_cook087720.95
    TC4203Fifty Years in Buckingham Palace Kitchenstrad_cook087711.95
    TC7777Sushi, Anyone?trad_cook087714.99



      









































































































































    title_id (1)advance (6)royalty (7)ytd_sales (8)
    BU10325,000.00104095
    BU11115,000.00103876
    BU207510,125.002418722
    BU78325,000.00104095
    MC22220.00122032
    MC302115,000.002422246
    MC3026NULLNULLNULL
    PC10357,000.00168780
    PC88888,000.00104095
    PC9999NULLNULLNULL
    PS13727,000.0010375
    PS20912,275.00122045
    PS21066,000.0010111
    PS33332,000.00104072
    PS77774,000.00103336
    TC32187,000.0010375
    TC42034,000.001415096
    TC77778,000.00104095



      






















































































































    title_id (1)notes (9)pubdate (10)
    BU1032An overview of available database systems with emphasis on common business applications.Illustrated.Jun 12 1991 12:00AM
    BU1111Helpful hints on how to use your electronic

    resources to the best advantage.    		Jun 9 1991 12:00AM
    BU2075The latest medical and psychological techniques for living

    with the electronic office.Easy-to-understand explanations.    		Jun 30 1991 12:00AM
    BU7832Annotated analysis of what computers can do for you:a no-hype guide for the critical user.Jun 22 1991 12:00AM
    MC2222Favorite recipes for quick, easy, and elegant meals.Jun 9 1991 12:00AM
    MC3021Traditional French gourmet recipes adapted for modern

    microwave cooking.    		Jun 18 1991 12:00AM
    MC3026NULLApr 28 1995 10:36AM
    PC1035A survey of software for the naive user, focusing on "friendliness" of each.Jun 30 1991 12:00AM
    PC8888Muckraking reporting on the world's largest computer

    hardware and software manufacturers.    		Jun 12 1994 12:00AM
    PC9999A must-read for computer conferencing.Apr 28 1995 10:36AM
    PS1372A must for the specialist, examining the difference between

    those who hate and fear computers and those who don't.    		Oct 21 1991 12:00AM
    PS2091Carefully researched study of the effects of strong

    emotions on the body.Metabolic charts included.    		Jun 15 1991 12:00AM
    PS2106New 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
    PS3333What happens when the data runs dry?Searching evaluations

    of information-shortage effects.    		Jun 12 1991 12:00AM
    PS7777Protecting 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
    TC3218Profusely illustrated in color, this makes a wonderful gift

    book for a cuisine-oriented friend.    		Oct 21 1991 12:00AM
    TC4203More anecdotes from the Queen's favorite cook describing

    life among English royalty.Recipes, techniques, tender

    vignettes.    		Jun 12 1991 12:00AM
    TC7777Detailed instructions on how to make authentic Japanese

    sushi in your spare time.    		Jun 12 1991 12:00AM



      


    相关文章
    本页查看次数: