SQL Server Data Types - 34 Data Types in 15 Minutes скачать в хорошем качестве

SQL Server Data Types - 34 Data Types in 15 Minutes

#DecodeITeS SQL Server Data Types SQL Server Data Types Types of SQL Server Data Types Categories of SQL Server Data Types Exact numeric Approximate numeric Date and time Character strings Unicode character strings Binary strings Other data types In SQL Server, Type of data hold by column in table, variable, or parameter is called Data Type. Data can be text, integer, date or sting, SQL Server covers all options with a variety of available data types.   E.g.:- In You collage Records, Your Name is the Alphabet field. Date of Birth is the Date field. Marks Obtained is Numeric \ Integer filed. Contact Number is Numeric \ Integer filed. Fee is Money Filed.   Developers need to be very careful to select the appropriate data type for each need during database designing. Each data type has it’s lower & upper range with storage & memory requirement, correct data type helps DB engine for better data management as well as the boost in performance optimization and database management by Database Administrators. Types of SQL Server Data Types Default \ Built-in Data Types:- As the name implies, default or built-in data types comes with SQL Server installation. These data types are divided into 7 categories.   User-Defined \ Customized Data Types:- SQL Server gives you the flexibility to create customized data types based on existing default data types with additional checks. Customized data types are database level property and valid on the current database only. These are very useful for developers to define data type once and can use then across the database. We will discuss customized data types in the next lesson. Categories of SQL Server Data Types SQL Server supports multiple datatypes and those data types are divided into following categories: Exact numeric: bit, tinyint, smallint, int, bigint, decimal, numeric, money and smallmoney Approximate numeric: Read and float Date and time: date, DateTime, datetime2, datetimeoffset, smalldatetime, time Character strings: char, varchar, text Unicode character strings: Nchar, Nvarchar, Ntext Binary strings: Binary, image and varbinary Other data types: Cursor, hierarchyid, sql_variant, table, rowversion, uniqueidentifier, XML, Spatial and geography