Variables and Data Types in SQL Server Transact-SQL

Q

Where to find answers to frequently asked questions on variables and data types in Microsoft SQL Server Transact-SQL? I am new to Transact-SQL and SQL Server.

✍: FYIcenter.com

A

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team on variables and data types in Microsoft SQL Server Transact-SQL. Clear answers are provided with tutorial exercises on entering data constants or literals; quoted character strings; date and time formats and ranges; integer and exact number literals; floating number precisions and ranges.

What Is Variable in SQL Server Transact-SQL

List of Data Types in SQL Server Transact-SQL

Exact Numeric Data Types in SQL Server Transact-SQL

Overflow Errors with INT Values in SQL Server Transact-SQL

Overflow and Rounding on NUMERIC Values in SQL Server Transact-SQL

Approximate Numeric Data Types in SQL Server Transact-SQL

Precision and Rounding of FLOAT Values in SQL Server Transact-SQL

Underflow and Overflow of FLOAT Values in SQL Server Transact-SQL

Differences of DECIMAL and FLOAT in SQL Server

Date and Time Data Types in SQL Server Transact-SQL

Entering Date and Time Values in SQL Server

Casting Numeric Values to DATETIME in SQL Server Transact-SQL

Entering 0.001 Second in DATETIME in SQL Server Transact-SQL

Date-Only DATETIME Values in SQL Server Transact-SQL

Time-Only DATETIME Values in SQL Server Transact-SQL

Out-of-Range DATETIME Values in SQL Server Transact-SQL

Single-Byte Character Data Types in SQL Server Transact-SQL

Unicode Character Data Types in SQL Server Transact-SQL

Differences of CHAR and NCHAR in SQL Server Transact-SQL

Differences of CHAR and VARCHAR in SQL Server Transact-SQL

Binary String Data Types in SQL Server Transact-SQL

DECLARE Statements in SQL Server Transact-SQL

SET Statements in SQL Server Transact-SQL

PRINT Statements in SQL Server Transact-SQL

CONVERT/CAST Function in SQL Server Transact-SQL

 

⇒⇒SQL Server Transact-SQL Tutorials

2017-04-22, 319👍, 0💬