General MySQL Oracle SQL Server

<< < … 27 28 29 30 31 32 33 34 35 36 37 … > >>   ∑:1354  Sort:Date

DECLARE Statements in SQL Server Transact-SQL
How to declare a variable in SQL Server Transact-SQL? How to use the DECLARE statements? In Transact-SQL, you must use DECLARE statements to declare variables. Declaring a variable is to define the variable name and the variable data type. In Transact-SQL, you can: Declare a single variable in a sin... 2017-04-04, 2484🔥, 0💬

Update Column Values on Multiple Rows in MySQL
How To Update Column Values on Multiple Rows in MySQL? If the WHERE clause in an UPDATE matches multiple rows, the SET clause will be applied to all matched rows. This rule allows you to update values on multiple rows in a single UPDATE statement. Here is a good example: mysql&gt; UPDATE fyi_lin... 2018-01-13, 2483🔥, 0💬

Left Outer Join with the WHERE Clause in Oracle
How To Write a Left Outer Join with the WHERE Clause in Oracle? If you don't want to use the LEFT OUTER JOIN ... ON clause to write a left outer join, you can use a special criteria in the WHERE clause as "left_table.column = right_table.column(+)". The select statement below is an example of a left... 2019-10-18, 2481🔥, 0💬

Creating New Tables with SELECT Statements in MySQL
How To Create a New Table by Selecting Rows from Another Table in MySQL? Let's say you have a table with many data rows, now you want to create a backup copy of this table of all rows or a subset of them, you can use the "CREATE TABLE ... SELECT" statement. The tutorial script below gives you a good... 2018-03-04, 2480🔥, 0💬

What Is MySQL Server Daemon - mysqld in MySQL
What Is the MySQL Server Daemon - mysqld in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background on your computer system. Invoking "mysqld" will start the MySQL server on your system. Terminating "mysqld" will shutdown the MySQL server. Here is a tutorial example of invoki... 2017-12-09, 2479🔥, 0💬

Importance of Column Order in the SET Clause in Update Statements in SQL Server
Is the Order of Columns in the SET Clause Important in SQL Server? The answer is NO. The order of columns in the SET clause of the UPDATE statement is NOT important. You probably already noticed from the previous tutorial. There is a BIG DIFFERENCE among SQL Server, MySQL and Oracle on update multip... 2016-11-02, 2479🔥, 0💬

Working with Database Objects in Oracle PL/SQL
Where to find answers to frequently asked questions on Working with Database Objects in Oracle PL/SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Working with Database Objects in Oracle PL/SQL. Clear answers are provided with tutorial exercis... 2018-10-13, 2478🔥, 0💬

Character String Functions Supported by SQL Server 2005 in SQL Server
What Are the Character String Functions Supported by SQL Server 2005 in SQL Server Transact-SQL? SQL Server 2005 supports 23 character string functions: ASCII(char) - Returning the code value of a non-Unicode character. CHAR(int) - Returning the non-Unicode character of a code value. CHARINDEX(word,... 2017-03-07, 2478🔥, 0💬

What are Date and Time Data Types in MySQL
What Are Date and Time Data Types in MySQL? MySQL supports the following date and time data types: DATE - A date in the range of '1000-01-01' and '9999-12-31'. Default DATE format is "YYYY-MM-DD". DATETIME - A date with the time of day in the range of '1000-01-01 00:00:00' and '9999-12-31 23:59:59'.... 2018-03-24, 2477🔥, 0💬

Understanding and Managing Indexes in SQL Server
Where to find answers to frequently asked questions on Understanding and Managing Indexes in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Understanding and Managing Indexes in SQL Server. Clear answers are provided with tutorial exe... 2016-11-15, 2477🔥, 0💬

Testing Table for DML Statements in SQL Server
How To Create a Testing Table with Test Data in SQL Server? If you want to practice DML statements, like INSERT, UPDATE and DELETE statements, you should create a testing table. The tutorial exercise shows you a good example: CREATE TABLE fyi_links (id INTEGER PRIMARY KEY, url VARCHAR(80) NOT NULL, ... 2016-11-03, 2477🔥, 0💬

DDL Commands Supported in MySQL
How Many SQL DDL Commands Are Supported by "mysql" in MySQL? There are 4 SQL Data Definition Language (DDL) commands that are supported by "mysql". They are listed below with short descriptions: "CREATE dataObjectType dataObjectName" - Creates new databases, tables, views, triggers, indexes, and oth... 2018-04-21, 2476🔥, 0💬

What Is View in MySQL
What Is View in MySQL? A view is a logical table defined by a query statement.   ⇒ What Is Join in MySQL ⇐ What Is Index in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-07, 2476🔥, 0💬

Ways to End the Current Transaction in MySQL
How To End the Current Transaction in MySQL? There are several ways the current transaction can be ended implicitly or explicitly: In "Autocommit On" mode, a single-statement transaction will be ended implicitly when the execution of the statement ends. Changes will be committed. Running the COMMIT ... 2016-10-17, 2476🔥, 0💬

Date and Time Intervals in MySQL
What Are Date and Time Intervals in MySQL? A date and time interval is special value to be used to increment or decrement a date or a time at a given date or time unit. A data and time interval should be expression in the format of "INTERVAL expression unit", where "unit" and "expression" should fol... 2017-12-26, 2475🔥, 0💬

"ALTER FUNCTION" - Modifying Existing Functions in SQL Server
How To Modify an Existing User Defined Function in SQL Server Transact-SQL? If you find a mistake in an existing function previously created, you can drop (delete) it and create it again correctly. But dropping a function may affect other database objects who are depending on this function. So the b... 2016-12-18, 2475🔥, 0💬

CREATE INDEX - Impact on Other User Sessions in SQL Server
What Is the Impact on Other User Sessions When Creating Indexes in SQL Server? If you are creating a new index on a table with existing data, all existing rows will be indexed as part of the CREATE INDEX statement. If the table is large, the indexing process could take some time. The impact of this ... 2016-11-08, 2475🔥, 0💬

Order of Columns in the SET Clause in MySQL
Is the Order of Columns in the SET Clause Important in MySQL? Yes. The order of columns in the SET clause of the UPDATE statement is important. There is a BIG DIFFERENCE between MySQL and Oracle on update columns with previous values: Oracle provides you the existing values from the database on colu... 2018-01-13, 2474🔥, 0💬

Create a New User Account in Oracle
How To Create a New User Account in Oracle? If you want to create a new user account, you can log in as SYSTEM and use the CREATE USER command as shown in the following example: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; CREATE USER DEV IDENTIFIED BY dev... 2019-07-21, 2473🔥, 0💬

BETWEEN - Testing Value in a Range in SQL Server
What To Test Value Ranges with the BETWEEN Operator in SQL Server Transact-SQL? Sometimes you want to compare a value against a value range. You can do this with two regular comparison operations. But you can also use the special comparison operator BETWEEN to get it done with the following syntaxes... 2017-01-21, 2473🔥, 0💬

What Is a SELECT Query Statement in SQL Server
What Is a SELECT Query Statement in SQL Server? The SELECT statement is also called the query statement. It is the most frequently used SQL statement in any database application. SELECT statements allows you to retrieve data from one or more tables or views, with different selection criteria, groupi... 2016-10-26, 2472🔥, 0💬

Show All Tables in a Database in MySQL
How To Get a List of All Tables in a Database in MySQL? If you want to see the table you have just created, you can use the "SHOW TABLES" command to get a list of all tables in database. The tutorial script gives you a good example: mysql&gt; SHOW TABLES; +---------------+ | Tables_in_fyi | +---... 2018-03-10, 2471🔥, 0💬

Creating Triggers for INSERT Statements Only in SQL Server
How To Create a Trigger for INSERT Only in SQL Server? The trigger, dml_message, provided in previous tutorials was defined to handle all 3 types of DML statements, INSERT, UPDATE, and DELETE. If you do not want the trigger to handle all 3 types of DML statements, you can list only 1 or 2 of the sta... 2016-10-24, 2471🔥, 0💬

in Oracle
How To Delete All Rows from a Table in Oracle? If you want to delete all rows from a table, you have two options: Use the DELETE statement with no WHERE clause. Use the TRUNCATE TABLE statement. The TRUNCATE statement is more efficient the DELETE statement. The tutorial exercise shows you a good exa... 2020-01-04, 2470🔥, 0💬

<< < … 27 28 29 30 31 32 33 34 35 36 37 … > >>   ∑:1354  Sort:Date

General MySQL Oracle SQL Server