LINETOTAL data type CustID Cust Type City 697 S Tooele PostalCode SalesOrderNum ProductID 84074 SO50270 863 Order Qty LineTotal ProductName ProductLine ProductListPrice 44 639.3717 Full-Finger Gloves, L M 37.99 146 L Seattle 98104 SO67266 869 41 1097.6182 Women's Mountain Shorts, L A 69.99 697 S Tooele 84074 SO51783 867 40 1259.82 Women's Mountain Shorts, S A 69.99 546 L Loveland 80537 SO57186 869 40 1259.82 Women's Mountain Shorts, L A 69.99 546 L Loveland 80537 SO48089 863 39 666.7245 Full-Finger Gloves, L M 37.99 146 L Seattle 98104 SO67266 867 38 1196.829 Women's Mountain Shorts, S A 69.99 697 302 125 315 SSSS Tooele 84074 SO51783 869 36 1133.838 Women's Mountain Shorts, L A 69.99 Offenbach 63009 SO51109 864 36 1028.7 Classic Vest, S S 63.5 Stamford 06901 SO46610 863 35 598.3425 S Merritt Island 32952 SO46673 863 35 598.3425 Full-Finger Gloves, L Full-Finger Gloves, L M 37.99 M 37.99 LineTotal is always present and is not stored as a currency. Data in column is representative of how many decimal places are stored. Highest allowed value is nine thousand i.e. 9000 Which ONE of the following is the most appropriate data type to use for LineTotal? O smallmoney O decimal(9) O decimal(8,4) O decimal(12,4) O decimal(4,4)
LINETOTAL data type CustID Cust Type City 697 S Tooele PostalCode SalesOrderNum ProductID 84074 SO50270 863 Order Qty LineTotal ProductName ProductLine ProductListPrice 44 639.3717 Full-Finger Gloves, L M 37.99 146 L Seattle 98104 SO67266 869 41 1097.6182 Women's Mountain Shorts, L A 69.99 697 S Tooele 84074 SO51783 867 40 1259.82 Women's Mountain Shorts, S A 69.99 546 L Loveland 80537 SO57186 869 40 1259.82 Women's Mountain Shorts, L A 69.99 546 L Loveland 80537 SO48089 863 39 666.7245 Full-Finger Gloves, L M 37.99 146 L Seattle 98104 SO67266 867 38 1196.829 Women's Mountain Shorts, S A 69.99 697 302 125 315 SSSS Tooele 84074 SO51783 869 36 1133.838 Women's Mountain Shorts, L A 69.99 Offenbach 63009 SO51109 864 36 1028.7 Classic Vest, S S 63.5 Stamford 06901 SO46610 863 35 598.3425 S Merritt Island 32952 SO46673 863 35 598.3425 Full-Finger Gloves, L Full-Finger Gloves, L M 37.99 M 37.99 LineTotal is always present and is not stored as a currency. Data in column is representative of how many decimal places are stored. Highest allowed value is nine thousand i.e. 9000 Which ONE of the following is the most appropriate data type to use for LineTotal? O smallmoney O decimal(9) O decimal(8,4) O decimal(12,4) O decimal(4,4)
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
Related questions
Question
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON