General MySQL Oracle SQL Server

<< < 1 2 3 4 5 6 7 8 … > >>   ∑:1365  Sort:Date

Revise and Rerun the Last SQL Command in Oracle
How To Revise and Re-Run the Last SQL Command in Oracle? If executed a long SQL statement, found a mistake in the statement, and you don't want enter that long statement again, you can use the input buffer commands to the correct last statement and re-run it. The following tutorial exercise gives yo... 2020-07-15, 7896🔥, 0💬

sys.database_principals - Listing All User Names in SQL Server
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names defined in a database, you can use the system view, sys.database_principals as shown in this tutorial exercise: -- Login with sa -- Select a database USE FyiCenterData; GO -- List all user names SELEC... 2017-08-25, 7840🔥, 0💬

AND, OR, XOR, and NOT - Bitwise Operations in SQL Server
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations performed on one or two binary strings. SQL Server supports 4 bitwise operations: &amp; (Bitwise AND) - Performing the single bit Boolean operation "AND" on each bit position. | (Bitwise OR) - Perfor... 2017-02-25, 7815🔥, 0💬

Selecting All Columns of All Rows from a Table in SQL Server
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simplest query statement is the one that selects all columns of all rows from a single table: "SELECT * FROM tableName". The (*) in the SELECT clause tells the query to return all columns. The missing WHERE... 2016-10-26, 7815🔥, 0💬

Formatting Time Zone in +/-hh:mm Format in SQL Server
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, you know how to calculate the time zone value by using GETDATE() and GETUTCDATE() functions. But how can you format that time zone value in a nice looking format like +05:45 or -04:00? Unfortunately, S... 2017-02-08, 7747🔥, 0💬

ROUND() - Rounding Values to Specific Precisions in SQL Server
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need to round a numeric value to a specific precision. For example, you may want to round values in your financial statement to the precision of 1000.00. This can be done by the ROUND() function with the f... 2017-03-11, 7709🔥, 0💬

Downloading and Installing Microsoft .NET Framework Version 2.0 in SQL Server
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Version 2.0 is required by many Microsoft applications like SQL Server 2005. If you want download and install .NET Framework Version 2.0, you should follow this tutorial: 1. Go to the Microsoft .NET Framew... 2016-12-08, 7676🔥, 0💬

sys.server_principals - Listing All Login Names in SQL Server
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login names defined on the server, you can use the system view, sys.server_principals as shown in this tutorial exercise: -- Login with sa SELECT name, sid, type, type_desc FROM sys.server_principals WHERE type... 2016-10-20, 7648🔥, 0💬

Show Privileges of the Current User in Oracle
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are listed in two system views: DBA_SYS_PRIVS, and USER_SYS_PRIVS. You can find out what privileges a user currently has by running a query on those views as shown in the tutorial exercise below: &gt;.\bi... 2019-06-11, 7618🔥, 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, 7600🔥, 0💬

Oracle Database Basic Concepts
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team about Oracle database basic concepts: What Is Oracle in Oracle What Is an Oracle Database in Oracle What Is an Oracle Ins... 2025-09-18, 7486🔥, 1💬

Downloading SQL Server 2005 Express Edition in SQL Server
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 Express Edition is the free version of the Microsoft SQL Server 2005. If you are interested to try SQL Server 2005, you should follow this tutorial to download Microsoft SQL Server 2005 Express Edition... 2016-12-08, 7460🔥, 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, 7303🔥, 0💬

DYNAMIC - Creating Dynamic Cursors in SQL Server
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying table is changed after the cursor is opened, should the changes be reflected in the cursor result set? The answer is based on the update option used when creating the cursor. SQL SERVER supports two ... 2016-10-17, 7285🔥, 0💬

FLOOR, CEILING, ROUND - Converting Values to Integers in SQL Server
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a numeric value into an integer. SQL Server 2005 offers you a number of ways to do this: FLOOR(value) - Returning the largest integer less than or equal to the input value. The returning data type is th... 2017-03-22, 7271🔥, 0💬

Error: Imported Table Already Exists in Oracle
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a table that already exists, the Data Pump Import utility will return an error and skip this table. The following exercise shows you a good example: &gt;cd \oraclexe\app\oracle\product\1 0.2.0\serve... 2016-10-15, 7185🔥, 0💬

"GROUP BY" - Dividing Query Output into Multiple Groups in SQL Server
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, you want to divide the query output into multiple groups, and apply group functions on each individual groups. Dividing query output into multiple groups can be done with the GROUP BY clause. Here is t... 2016-10-25, 7070🔥, 0💬

NULLIF() - Replacing Given Values with NULL in SQL Server
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want to hide certain values by replacing them with NULL values. SQL Server offers you a nice function called NULLIF() to do this: NULLIF(expression, value) -- Returns NULL if "expression" equals to value" -... 2017-01-29, 6966🔥, 0💬

PHP Connections and Query Execution for MySQL
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on PHP Connections and Query Execution in MySQL. Clear explanations and tutorial exercises are provi... 2017-11-25, 6884🔥, 0💬

PL/SQL Language Case Insensitive in Oracle
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words are not case sensitive. For example: CASE and Case are identical. Variable names and other names are not case sensitive. For example: TOTAL_SALARY and total_salary are identical. But values in string l... 2018-12-26, 6858🔥, 0💬

What Is Transport Network Substrate in Oracle
What Is Transport Network Substrate (TNS) in Oracle? TNS, Transport Network Substrate, is a foundation technology, built into the Oracle Net foundation layer that works with any standard network transport protocol.   ⇒ What Is ODBC in Oracle ⇐ What Is SQL*Plus in Oracle ⇑ Oracle Database Basic Conc... 2025-09-30, 6832🔥, 1💬

ICU_VERSION() - ICU (International Components for Unicode) Version
How to obtain the version number of the ICU (International Components for Unicode) library using the ICU_VERSION() function? ICU_VERSION() is a MySQL built-in function that returns the version number of the ICU (International Components for Unicode) library. For example: SELECT ICU_VERSION(); -- +--... 2025-04-11, 6813🔥, 0💬

Recover a Dropped Index in Oracle
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped indexes are stored in the recycle bin. But it seems to be command to restore a dropped index out of the recycle bin. FLASHBACK INDEX is not a valid statement. See the following script: ALTER SESSION SET ... 2019-04-22, 6806🔥, 0💬

Is SQL Server Transact-SQL Case Sensitive?
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard SQL, you can type in your Transact-SQL statement in upper case or lower case. However, you should use upper case for all key words in Transact-SQL statements as a best practice. The following example... 2017-06-16, 6727🔥, 0💬

<< < 1 2 3 4 5 6 7 8 … > >>   ∑:1365  Sort:Date

General MySQL Oracle SQL Server