<< < 1 2 3 4 5 6 7 8 9 > >>   Sort: Date

Constant or Data Literal in SQL Server Transact-SQL
What Is a Constant or Literal in SQL Server Transact-SQL? A constant, or data literal, is a symbolic expression that represents a specific value of a specific data type in SQL Server Transact-SQL. Constants or literals are used commonly as the default values for table columns, variables, and paramet...
2017-05-20, 311👍, 0💬

CONVERT() - Formatting DATETIME Values to Strings in SQL Server
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL Server 2005 offers no functions to format DATETIME values in your own format patterns. But it does provide you a number of pre-defined format patterns that you can use with the CONVERT(char_type, dat...
2017-02-08, 310👍, 0💬

"@@FETCH_STATUS" - Looping through Result Set in SQL Server
How To Loop through the Result Set with @@FETCH_STATUS in SQL Server Transact-SQL? The FETCH statement only returns one row from the result set. If you want to return all rows, you need to put the FETCH statement in a loop. A simple way to stop the loop to check the system variable @@FETCH_STATUS, w...
2016-10-17, 309👍, 0💬

Exact Numeric Literals in SQL Server Transact-SQL
What are exact numeric literals supported in SQL Server Transact-SQL? Exact numeric literals in Transact-SQL are numbers written in standard signed decimal formats. Exact numeric literals are used to provide values to exact numeric variables or table columns like INTEGER, DECIMAL(8,2), MONEY, etc. E...
2017-05-05, 308👍, 0💬

Converting Numeric Data Types by Assignment Operations in SQL Server
How To Convert Numeric Expression Data Types by Assignment Operations in SQL Server Transact-SQL? An assignment operation is used to assign an expression to a variable, a column, or a parameter. If the data type of the expression does not match the data type of the receiving variable, column, or par...
2017-03-27, 307👍, 0💬

"IF ... ELSE IF ..." Statement Structures in SQL Server
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ..." statement structure is used to select one of the specified statements to be executed based on specified Boolean conditions. Here is the syntax of "IF ... ELSE IF ..." statement structure: IF conditi...
2017-01-11, 307👍, 0💬

Calculating Age in Days, Hours and Minutes in SQL Server
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news items or blog articles are displayed with a publishing data and time represented in days, hours and minutes. To do this you can use the DATEDIFF() function with a simple algorithm as shown in the tuto...
2017-02-14, 306👍, 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, 303👍, 0💬

Verify Time Precision in SQL Server Transact-SQL
How to verify the precession of the server system time in SQL Server Transact-SQL? You can run a WHILE loop to check the precision of server system time in Transact-SQL as shown below: DECLARE @var DATETIME2(7); DECLARE @count INT = 0; WHILE @count<100 BEGIN SET @count = @count + 1; SET @var = SY...
2017-02-22, 303👍, 0💬

DATEDIFF() - Calculating DATETIME Value Differences in SQL Server
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL? If you want to calculate the difference between two date and time values, you can use the DATEDIFF() function in the following format: DATEDIFF(datepart, startdate, enddate) returns INT: "startdate"...
2017-02-20, 302👍, 0💬

Statement Batch in SQL Server Transact-SQL
What is statement batch in SQL Server Transact-SQL? A statement batch is a group of one or more Transact-SQL statements sent at the same time from an application to SQL Server for execution. SQL Server compiles the statements of a batch into a single executable unit, called an execution plan. The st...
2017-05-29, 301👍, 0💬

Binary String Data Types in SQL Server Transact-SQL
What are binary string data types supported in SQL Server Transact-SQL? Binary string data types are used to hold binary character strings. There are 3 binary string data types supported in SQL Server Transact-SQL: 1. BINARY - Used to hold binary strings of a fixed length, specified in the format of...
2017-04-04, 301👍, 0💬

Converting Binary Strings into Integers in SQL Server
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers are convertible implicitly and explicitly. But there several rules you need to remember: Binary strings will be implicitly converted into an integer data type, if it is involved in an arithmetical ope...
2017-02-28, 301👍, 0💬

BEGIN ... END Statement Blocks in SQL Server Transact-SQL
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into a statement block with BEGIN and END key words in Transact-SQL using these syntaxes BEGIN statement_1 statement_2 ... END Statement blocks are mainly used with logical conditions and control-of-flow ...
2017-01-11, 301👍, 0💬

SET Statements in SQL Server Transact-SQL
How to assign value to a variable in SQL Server Transact-SQL? How to use the SET statements? In Transact-SQL, you can use SET statements to assign values to variables using the assignment operator =, in the syntax of: SET @variable = <value> When an SET statement is executed, the system will: ...
2017-04-04, 300👍, 0💬

Get System Date and Time in SQL Server Transact-SQL
How to get system date and time in SQL Server Transact-SQL? I want a list of functions for getting current system date and time. Here is a comparison of all functions that you can use to get the current date and time from the data base server system: Function Return type Precision ------------------...
2017-02-25, 300👍, 0💬

Converting DATETIME and NUMERIC Values in SQL Server
Are DATETIME and NUMERIC Values Convertible in SQL Server Transact-SQL? Are datetime and numeric value convertible? The answer is yes. Here are the main rules on DATATIME and NUMERIC value conversions: During the conversion a DATETIME value will be treated as a NUMERIC value with the number of days ...
2017-02-22, 300👍, 0💬

SQL Server Transact-SQL Language References
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL language references on Microsoft Website: Transact-SQL Reference for SQL Server 2016 Transact-SQL Reference for SQL Server 2014 Transact-SQL Reference for SQL Server 2012 Transact-SQL Reference for SQL Se...
2017-05-20, 299👍, 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, 299👍, 0💬

Character Strings and Binary Strings in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Character Strings and Binary Strings in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Character Strings and Binary Strings in SQL Server Transact-SQL. Clear answers ...
2017-03-11, 299👍, 0💬

Where Is the Export Dump File Located in Oracle
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and file name, the dump file will be stored in the default dump directory with the default file name. The tutorial exercise below tells you find what is your default dump directory and locate the dump file....
2016-10-15, 299👍, 0💬

Converting Unicode Strings to Non-Unicode Strings in SQL Server
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode character set is different than code page based (non-Unicode) character set, converting Unicode strings to non-Unicode strings may result in wrong characters or missing characters. So you should avoid c...
2017-03-07, 298👍, 0💬

bin2hex - Converting Binary Strings into Hexadecimal Character Strings in SQL Server
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns a binary string value to the client tool, it will be displayed by the client tool as hexadecimal digits in a character string format. But they are hexadecimal digits on the display window, not in the...
2017-02-25, 298👍, 0💬

Getting Year, Month and Day Out of DATETIME Values in SQL Server
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPART() to get any part of the DATETIME value. But to get year, month and day, you can use 3 specific functions: YEAR(), MONTH() and DAY(). These functions are equivalent to DATEPART() as: YEAR(date) = D...
2017-02-14, 297👍, 0💬

<< < 1 2 3 4 5 6 7 8 9 > >>   Sort: Date