General MySQL Oracle SQL Server

<< < 1 2 3 4 5 6 7 8 … > >>   ∑:1360  Sort:Rank

JSON_TABLE() - Inline Table with JSON Array
How to create an inline table with a JSON Array using the JSON_TABLE() function? JSON_TABLE(json, path COLUMNS (column_list) AS alias) is a MySQL built-in function that creates an inline table by parsing JSON array members. For example: the following statement creates a 1-column table with string me... 2024-11-23, 1547🔥, 0💬

JSON_SCHEMA_VALID() - JSON Schema Validation
How to validate a JSON value against a JSON schema using the JSON_SCHEMA_VALID() function? JSON_SCHEMA_VALID(schema, json) is a MySQL built-in function that validates a JSON value against a given JSON schema. For example: SET @schema = '{ "id": "http://json-schema.org/geo", "$schema": "http://json-s... 2024-11-23, 1526🔥, 0💬

BIN() - Converting Integer to Binary String
How to convert an integer to a binary string using the BIN() function? BIN(int) is a MySQL built-in function that converts an integer to binary string. For example: SELECT BIN(1), BIN(2), BIN(4), BIN(8), BIN(16), BIN(1024); -- +--------+--------+--------+-- ------+---------+------------- +-- | BIN(1)... 2024-11-23, 1361🔥, 0💬

Removed: ENCODE() - Encoding Data with Password
How to encode a byte sequence with a given password using the ENCODE() function? ENCODE(clear, pass) is a MySQL built-in function that encodes a byte sequence with a given password using the default encoding algorithm. Note that ENCODE() is no longer supported. It was: Introduced MySQL 4.0. Removed ... 2024-10-14, 3112🔥, 0💬

Removed: DES_ENCRYPT() - DES Data Encryption
How to encrypt data with the DES (Data Encryption Standard) algorithm using the DES_ENCRYPT() function? DES_ENCRYPT(clear, key) is a MySQL built-in function that encrypts data with the DES (Data Encryption Standard) algorithm. Note that DES_ENCRYPT() is no longer supported. It was: Introduced MySQL ... 2024-10-14, 1748🔥, 0💬

Removed: DES_DECRYPT() - DES Data Decryption
How to decrypt data with the DES (Data Encryption Standard) algorithm using the DES_DECRYPT() function? DES_DECRYPT(cipher, key) is a MySQL built-in function that decrypts data with the DES (Data Encryption Standard) algorithm. Note that DES_DECRYPT() is no longer supported. It was: Introduced MySQL... 2024-10-14, 1669🔥, 0💬

Removed: DECODE() - Decoding Data with Password
How to decode a byte sequence generated from the ENCODE() function using the DECODE() function? DECODE(cipher, pass) is a MySQL built-in function that encodes a byte sequence generated from the ENCODE() function. Note that DECODE() is no longer supported. It was: Introduced MySQL 4.0. Removed in MyS... 2024-10-14, 1575🔥, 0💬

Removed MySQL Functions
Where to find answers to frequently asked questions about Removed MySQL Built-in Functions? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team about Removed MySQL Built-in Functions: Removed: ENCODE() - Encoding Data with Password Removed: DECODE() - Decodi... 2024-10-14, 1508🔥, 0💬

DENSE_RANK() - Density Rank of Sorted Values
How to calculate the density rank of the sorting field expression in the current result set window using the DENSE_RANK() function? DENSE_RANK() is a MySQL built-in window function that calculates the density rank of the sorting field expression in the current result set window. For example: SELECT ... 2024-09-28, 2106🔥, 0💬

LAG() - N-Row before Current Row within Window
How to evaluate a field expression on n-row before the current row in the current result set window using the LAG() function? LAG(exp, n, default) is a MySQL built-in window function that evaluates a field expression on n-row before the current row in the current result set window. For example: SELE... 2024-09-28, 1956🔥, 0💬

FIRST_VALUE() - First Value of Result Set Window
How to obtain the first value of a field expression in the current result set window using the FIRST_VALUE() function? FIRST_VALUE(exp) is a MySQL built-in window function that returns the first value of a field expression in the current result set window. For example: SELECT help_topic_id AS tip, h... 2024-09-28, 1800🔥, 0💬

LAST_VALUE() - Last Value of Result Set Window
How to obtain the last value of a field expression in the current result set window using the LAST_VALUE() function? LAST_VALUE(exp) is a MySQL built-in window function that returns the last value of a field expression in the current result set window. For example: SELECT help_topic_id AS tip, help_... 2024-09-28, 1765🔥, 0💬

LEAD() - N-Row after Current Row within Window
How to evaluate a field expression on n-row after the current row in the current result set window using the LEAD() function? LEAD(exp, n, default) is a MySQL built-in window function that evaluates a field expression on n-row after the current row in the current result set window. For example: SELE... 2024-09-28, 1626🔥, 0💬

RANK() - Vale Rank of Sorted Values
How to calculate the value rank of the sorting field expression in the current result set window using the RANK() function? RANK(n) is a MySQL built-in window function that calculates the value rank of the sorting field expression in the current result set window. For example: SELECT help_topic_id A... 2024-09-12, 1758🔥, 0💬

NTILE() - Dividing Window into N Tiles
How to divid result set window into N tiles and return the tile position using the NTILE() function? NTILE(n) is a MySQL built-in window function that divides result set window into n tiles and returns the tile position of the current row. For example: SELECT help_topic_id AS tip, help_category_id A... 2024-09-12, 1734🔥, 0💬

NTH_VALUE() - N-th Value of Result Set Window
How to obtain the n-th value of a field expression in the current result set window using the NTH_VALUE() function? NTH_VALUE(exp, n) is a MySQL built-in window function that returns the n-th value of a field expression in the current result set window. For example: SELECT help_topic_id AS tip, help... 2024-09-12, 1511🔥, 0💬

ROW_NUMBER() - Row Position in Result Set Window
How to obtain the row position of the current row in the current result set window using the ROW_NUMBER() function? ROW_NUMBER(n) is a MySQL built-in window function that returns the row position of the current row in the current result set window. For example: SELECT help_topic_id AS tic, help_cate... 2024-09-12, 1324🔥, 0💬

PERCENT_RANK() - Rank Percentage of Sorted Values
How to calculate the rank percentage of the sorting field expression in the current result set window using the PERCENT_RANK() function? PERCENT_RANK(n) is a MySQL built-in window function that calculates the rank percentage of the sorting field expression in the current result set window. For examp... 2024-09-12, 1221🔥, 0💬

SQL Server Connection Protocols
What connection protocols are supported by SQL Server? SQL Server supports the following connection protocols: 1. TCP/IP (Transmission Control Protocol/Internet Protocol) - This is the most commonly used protocols to connect to SQL Server databases. It allow client tools or application programs on a... 2024-08-14, 3038🔥, 0💬

SQL Server TCP/IP Connection Info
What information is needed for a client tool or application to connect to a SQL Server database using the TCP/IP protocol? In order to connect to a SQL Server database using the TCP/IP protocol, you need to know the following information: 1. Host Name - The name of the hosting computer where the SQL... 2024-08-14, 2979🔥, 0💬

Configuring ODBC Connection and DSN for SQL Servers
A collection of 13 FAQs on connecting SQL Server via an ODBC DSN setting. Clear explanations and tutorial exercises are provided on creating new DSN with the SQL Server ODBC driver; starting SQL Server Browser Service; enabling TCP/IP protocol on SQL Server; verifying TCP/IP port numbers; testing OD... 2024-08-14, 2967🔥, 0💬

What Is ODBC (Open Database Communication)?
What Is Open Database Communication (ODBC)? ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management servers. If you want to access a database server through an ODBC driver from an applic... 2024-08-14, 2823🔥, 0💬

SQL Server Connection Concepts
Where to find answers to frequently asked questions on SQL Server Connection Concepts? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Server Connectivity Concepts. SQL Server Connection Protocols SQL Server TCP/IP Connection Info   ⇒ SQL Serv... 2024-08-14, 2525🔥, 0💬

Adding a New DSN with the ODBC Driver for SQL Server
How To Add a New DSN with the ODBC Driver for SQL Server? Assuming that the ODBC driver for SQL Server has been installed as part of the Windows system, the next step of setting up ODBC connection to SQL Server is to create a new DSN (Data Source Name) with the ODBC Data Source Administrator: Go to ... 2024-08-06, 2763🔥, 0💬

<< < 1 2 3 4 5 6 7 8 … > >>   ∑:1360  Sort:Rank

General MySQL Oracle SQL Server