General MySQL Oracle SQL Server

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

"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, 6535🔥, 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, 6484🔥, 0💬

CHAR(n) - Truncating/Padding Strings in SQL Server Transact-SQL
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the input string does not match the storage size of the fixed length string data type CHAR(n). SQL Server will: If the input string of CHAR(n) has less than n bytes, it will be padded with space characte... 2017-05-13, 6475🔥, 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, 6475🔥, 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, 6430🔥, 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, 6417🔥, 1💬

FOUND_ROWS() - Row Count from Last SELECT Statement
How to obtain the number of rows found by the last SELECT statement using the FOUND_ROWS() function? FOUND_ROWS() is a MySQL built-in function that returns the number of rows found by the last SELECT statement. For example: SELECT help_topic_id, name FROM mysql.help_topic; -- +---------------+------... 2025-04-11, 6399🔥, 0💬

Differences between DATE and TIMESTAMP in Oracle
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and TIMESTAMP are: DATE stores values as century, year, month, date, hour, minute, and second. TIMESTAMP stores values as year, month, day, hour, minute, second, and fractional seconds.   ⇒ Differences b... 2020-04-25, 6307🔥, 0💬

Show All Data Files in the Current Database in Oracle
How To View Data Files in the Current Database in Oracle? If you want to get a list of all tablespaces used in the current database instance, you can use the DBA_TABLESPACES view as shown in the following SQL script example: SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; col tablespace_... 2019-04-13, 6255🔥, 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, 6246🔥, 0💬

Installing PHP on Windows in MySQL
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems is to: Go to http://www.php.net, which is the official Web site for PHP. Download PHP binary version for Windows in ZIP format. Unzip the downloaded file into a directory. You are done. No need to run... 2017-07-30, 6094🔥, 0💬

Privilege to Delete Rows in Another Schema in Oracle
What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema in Oracle? For a user to delete rows from tables of someone else's schema, he/she needs the DELETE ANY TABLE privilege. The following tutorial exercise gives you a good example of granting "dev" to delete rows in "hr" s... 2019-06-11, 5989🔥, 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, 5951🔥, 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, 5920🔥, 0💬

"ALTER USER" - Changing the Name of a Database User in SQL Server
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existing database user, you can use the "ALTER USER" statement as shown in the tutorial exercise below: -- Login with "sa" USE FyiCenterData; GO ALTER USER Fyi_User WITH NAME = Dba_User; GO -- List all user... 2022-01-24, 5917🔥, 0💬

Start with a Minimum Initialization Parameter File in Oracle
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initialization parameter file provided by Oracle seems to be not working. But we can try to start the new instance with a minimal initialization parameter file (PFile). First you can create another PFile, $ORACL... 2018-05-08, 5897🔥, 0💬

Connect ASP Pages to Oracle Servers in Oracle
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and serving ASP Web pages, you can get data from Oracle servers into your ASP pages through ODBC drivers. To do this, you need to install the correct Oracle ODBC driver and define a DSN on the IIS Web ser... 2016-10-15, 5804🔥, 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, 5737🔥, 0💬

Converting Numeric Values to Character Strings in MySQL
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to character strings by using the CAST(value AS CHAR) function as shown in the following examples: SELECT CAST(4123.45700 AS CHAR) FROM DUAL; 4123.45700 -- How to get rid of the last 2 '0's? SELECT CAST(4.123... 2018-03-28, 5721🔥, 0💬

Connecting SQL Server Management Studio Express To a SQL Server in SQL Server
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once you have SQL Server 2005 Express installed and running on your local machine, you are ready to connect SQL Server Management Studio Express to the server: Click Start &gt; Programs &gt; Microso... 2016-12-04, 5712🔥, 0💬

"USE" - Setting the Current Database in SQL Server
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should select a database to work with and set it as the current database using the "USE" statement with this syntax: USE database_name The following tutorial example shows you how to set "FyiCenterData" as t... 2016-11-24, 5695🔥, 0💬

Verifying PHP Installation in MySQL
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line Interface (CLI) and Common Gateway Interface (CGI). If PHP is installed in the \php directory on your system, you can try this to check your installation: Run "\php\php -v" command to check the Command ... 2017-07-30, 5661🔥, 0💬

Difference Between GETDATE() and GETUTCDATE() in SQL Server
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference between GETDATE() and GETUTCDATE() is time zone number of the SQL Server machine. The tutorial exercise below gives you a good example: DECLARE @local_time DATETIME; DECLARE @gmt_time DATETIME; SET @... 2017-02-14, 5657🔥, 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, 5623🔥, 0💬

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

General MySQL Oracle SQL Server