Question

The data type used for '145' is​

Answer 1

Answer:

Data types are simultaneously the lifeblood and bane of data migration. They can literally make or break  

your ETL process. The first, and indeed the fundamental, aspect of a successful data load process is data type  

mapping. Quite simply, if any source data is a type that SQL Server cannot understand, then an import is likely  

to fail.  

Therefore (and as a quick refresher course), this appendix presents the data types that you need to  

understand, first in SQL Server, and then in SSIS.  

SQL Server Data Types  

Table A-1 is a quick overview of SQL Server data types. I realize that data types are not exactly the most exciting  

thing on the planet, but they are fundamental to data ingestion and data type validation. So even if you never  

learn this stuff by heart, at least you have it here as an easily available reference.  

Table A-1. SQL Server Data Type Ranges and Storage  

Data Type Description Range Storage  

Bigint Large integer—exact numeric −9,223,372,036,854,775,808 to  

9,223,372,036,854,775,807  

8 bytes  

Int Integer −2,147,483,648 to 2,147,483,647 4 bytes  

Smallint Small integer—exact numeric −32,768 to 32,767 2 bytes  

Tinyint Tiny integer—exact numeric 0 to 255 1 byte  

Bit Binary digit 0 or 1 1 byte  

Decimal (p[ , s] )—precision and scale Precision of 1–9: 5 bytes  

Precision of 10–19: 9 bytes  

Precision of 20–28: 13 bytes  

Precision of 29–38: 17 bytes  

Numeric Same as numeric  

Money Accurate to 4 decimal places −922,337,203,685,477.5808 to  

922,337,203,685,477.5807  

8 bytes  

Smallmoney Accurate to 4 decimal places − 214,748.3648 to 214,748.3647 4 bytes  

(continued)APPENDIX A ■ DATA TYPES

932

Data Type Description Range Storage  

Float Approximate number typefor  

use with floating point  

numeric data  

− 1.79E+308 to −2.23E−308, 0  

and 2.23E−308 to 1.79E+308  

Depends on the value  

being stored  

Real Approximate number typefor  

use with floating point  

numeric data  

− 3.40E + 38 to −1.18E – 38, 0  

and 1.18E – 38 to 3.40E + 38  

4 bytes  

Datetime January 1, 1753 toDecember  

31, 9999  

Datetime2 01/01/0001to13/12/9999  

DateTimeOffset  

Smalldatetime January 1, 1900 toJune 6, 2079  

Char (n) Fixed-length, single-byte  

character  

8000 characters N bytes  

Varchar (n) Variable-length, single-byte  

Explanation:

pls mark me as brainliest and follow for more great answers

Answer 2

Answer:

8000 charecter N bytes

Explanation:

8000 charecter n byetes