Let's take a look at the SQL Server data type table, which lists the most common types: classification notes and description data type description binary data types store non-sub-characters and text dataImageuse to store image text data type character data includes any combination of letters, symbols, or numeric charactersCharfixed-length non-Unicodecharacter DataVarcharvariable length non-UnicodeDataNcharfixed-lengthUnicodeDataNvarcharvariable lengthUnicodeDataTextStoring long text informationNtextStore variable-length long text date and time dates and times in single quotesDatetimeDate and time numeric data This data contains only numbers, including positive, negative, and fractionalintsmallintintegerfloatRealnumeric Currency data type used for decimal currency values Moneythe bit data type indicates Yes/No DataBitStoring Boolean data types you can also go directly to the help document to find out when we created the table, we used to select the field name, data type, whether the definition is empty, etc. The data type here is required, and it provides a basic limitation and distinction between the types of values that can be inserted. So, just the type of limit is not enough, how to ensure that the data entered in the table is accurate and reliable? Next we will learn the integrity constraints of the data!
SQL Server data types