<< < 1 2 3 4 5 6 7 8 9 10 11 > >>   Sort: Rank

Error: Lock Wait Timeout Exceeded in MySQL
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives the "Lock wait timeout exceeded" - ERROR 1205, MySQL server automatically terminates your transaction and rolls back your data changes of the entire transaction. This is why the error messages tells you...
2017-04-28, 474👍, 0💬

What Is a Data Lock in MySQL
What Is a Data Lock in MySQL? MySQL uses two types of data locks at two levels to provide you the transaction isolation level you need: Share Lock at Row Level (S) - A data row is locked by a transaction for reading. Exclusive Lock at Row Level (X) - A data row is locked by a transaction for updatin...
2017-04-28, 366👍, 0💬

What Is a Dead Lock in MySQL
What Is a Dead Lock in MySQL? A dead lock is phenomenon happens between two transactions with each of them holding a lock that blocks the other transaction as shown in the following diagram: (transaction 1) (transaction 2) update row X to create lock 1 update row Y to create lock 2 update row X (blo...
2017-04-28, 365👍, 0💬

Experiment with Data Locks in MySQL
How To Experiment Data Locks in MySQL? If you want to have some experience with data locks, you can create two windows running two mysql transactions in two sessions. In session 1, you can run a UPDATE statement with REPEATABLE READ transaction isolation level to create an exclusive lock. Before com...
2017-04-28, 350👍, 0💬

Transaction Waiting for a Data Lock in MySQL
How Long a Transaction Will Wait for a Data Lock in MySQL? If you issue a UPDATE or DELETE statement on a row that has an exclusive lock owned by another session, your statement will be blocked to wait for the other session to release the lock. But the wait will be timed out after the predefined inn...
2017-04-28, 291👍, 0💬

Variables and Data Types in SQL Server Transact-SQL
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. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team on variables and data types in Microsoft SQL Se...
2017-04-22, 352👍, 0💬

Exact Numeric Data Types in SQL Server Transact-SQL
What are exact numeric data types supported in SQL Server Transact-SQL? Exact numeric data types are used to hold numeric values truncated to a specific precision and scale. There are 8 different exact numeric data types supported in SQL Server Transact-SQL: 1. BIGINT - Used to hold big integers wit...
2017-04-22, 323👍, 0💬

Entering Binary String Literals in SQL Server Transact-SQL
How To Enter Binary String Literals in SQL Server Transact-SQL? Binary string long values are normally generated by client applications by reading input channels, like image files. But sometimes, you may need to enter some short binary strings as literals. Binary string literals are entered as a str...
2017-04-22, 308👍, 0💬

What Is Variable in SQL Server Transact-SQL
What is a variable in SQL Server Transact-SQL? A variable in Transact-SQL is a symbolic name representing a memory storage that holds a piece of data. A variable has the following the components: 1. Variable name - A symbolic name to represent the variable. Variable names in Transact-SQL must starts...
2017-04-22, 305👍, 0💬

List of Data Types in SQL Server Transact-SQL
How many data types supported in SQL Server Transact-SQL? I want a list of all data types. Here is a list of all Transact-SQL data types divided into 6 categories: 1. Exact Number - Used to hold numeric values truncated to a specific precision and scale. BIGINT - Used to hold big integers. INT (or I...
2017-04-22, 288👍, 0💬

Underflow and Overflow of FLOAT Values in SQL Server Transact-SQL
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you enter a floating number that is too big or too small for the FLOAT data type, Transact-SQL will behave as: FLOAT(24) Underflow: If a floating number is too small for FLOAT(24), it will be stored as 0 w...
2017-04-19, 336👍, 0💬

Precision and Rounding of FLOAT Values in SQL Server Transact-SQL
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) should store the mantissa of the floating number in n bits. For example, FLOAT(16) should have a precision one-byte less than FLOAT(24). However, SQL Server Transact-SQL only supports two precisions for...
2017-04-19, 310👍, 0💬

Approximate Numeric Data Types in SQL Server Transact-SQL
What are approximate numeric data types supported in SQL Server Transact-SQL? Approximate numeric data types are used to hold numeric values with floating scales. There are 3 different approximate numeric data types supported in SQL Server Transact-SQL: 1. FLOAT - Used to hold values with different ...
2017-04-19, 301👍, 0💬

Overflow Errors with INT Values in SQL Server Transact-SQL
What Happens If an Integer Is Too Big for INT (INTEGER) Date Type in SQL Server Transact-SQL? If you are entering an INT data type literal with representing an integer value too big for INT data type to store, the SQL Server will give you an arithmetic overflow error. The same error will happen on B...
2017-04-19, 301👍, 0💬

Overflow and Rounding on NUMERIC Values in SQL Server Transact-SQL
How Extra Digits Are Handled with NUMERIC Data Type Literals in SQL Server Transact-SQL? Exact numeric data types defined with NUMERIC(p,s) has two limits defined by two parameters: p (precision) and s (scale): Maximum number of digits of the integer part (digits before the decimal point) is defined...
2017-04-19, 273👍, 0💬

Entering 0.001 Second in DATETIME in SQL Server Transact-SQL
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter milliseconds in data and time values, they will be rounded up to 10/3 millisecond increments, because DATETIME data type uses 4 bytes to store the time of the day. A 4-byte integer can only give an accuracy ...
2017-04-15, 357👍, 0💬

Differences of DECIMAL and FLOAT in SQL Server
What Are the Differences between DECIMAL and FLOAT in SQL Server Transact-SQL? DECIMAL and FLOAT are both used to store numerical values. But they have the following main differences: DECIMAL(p,s) stores values with the decimal point fixed at the position of s (scale) digits from the right. The tota...
2017-04-15, 322👍, 0💬

Date and Time Data Types in SQL Server Transact-SQL
What are date and time data types supported in SQL Server Transact-SQL? Date and time data types are used to hold dates and times. There are 6 date and time data types supported in SQL Server Transact-SQL: 1. DATETIME - Use to hold date and times with a large precision using 8-byte storages: 4 bytes...
2017-04-15, 316👍, 0💬

Casting Numeric Values to DATETIME in SQL Server Transact-SQL
Can I cast numeric values to DATETIME values in SQL Server Transact-SQL? Yes, you can cast numeric values to DATATIME values in Transact-SQL. The implicit casting rules are for numeric values to DATETIME values are: Numeric values are casted linearly to DATETIME values. Decimal 0 represents 1900-01-...
2017-04-15, 306👍, 0💬

Entering Date and Time Values in SQL Server
How To Enter Date and Time values in SQL Server Transact-SQL? Transact-SQL does not support date and time literals. If you want to enter date and time values, you have to use character string literals and rely implicit casting rules to convert them into date and time values. When casting character s...
2017-04-15, 277👍, 0💬

Date-Only DATETIME Values in SQL Server Transact-SQL
What Happens If Date-Only Values Are Provided for DATETIME in SQL Server Transact-SQL? If only date value is provided in a DATETIME variable, the SQL Server will pad the time value with a zero, or '00:00:00.000', representing the midnight time of the day. The tutorial exercise below gives you some g...
2017-04-08, 260👍, 0💬

Single-Byte Character Data Types in SQL Server Transact-SQL
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte character string data types are used to hold single-byte character strings. There are 3 single-byte character string data types supported in SQL Server Transact-SQL: 1. CHAR (or CHARACTER) - Used to ho...
2017-04-08, 357👍, 0💬

Time-Only DATETIME Values in SQL Server Transact-SQL
What Happens If Time-Only Values Are Provided for DATETIME variables in SQL Server Transact-SQL? If only time value is provided in a DATETIME variable, the SQL Server will pad the date value with a zero, representing the base date, January 1, 1900. The tutorial exercise below gives you some good exa...
2017-04-08, 330👍, 0💬

Unicode Character Data Types in SQL Server Transact-SQL
What are Unicode character string data types supported in SQL Server Transact-SQL? Unicode character string data types are used to hold Unicode character strings. There are 3 Unicode character string data types supported in SQL Server Transact-SQL: 1. NCHAR (or NATIONAL CHAR, or NATIONAL CHARACTER) ...
2017-04-08, 330👍, 0💬

<< < 1 2 3 4 5 6 7 8 9 10 11 > >>   Sort: Rank