General MySQL Oracle SQL Server

<< < … 30 31 32 33 34 35 36 37 38 39 40 … > >>   ∑:1349  Sort:Date

Sorting Query Output in MySQL
How To Sort the Query Output in MySQL? If you want the returning rows to be sorted, you can specify a sorting expression in the ORDER BY clause. The simplest sort expression is column name who's values will be sorted by. The following select statement returns rows sorted by the values in the "counts... 2017-11-02, 2297🔥, 0💬

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

Query with a Right Outer Join in Oracle
How To Write a Query with a Right Outer Join in Oracle? If you want to query from two tables with a right outer join, you can use the RIGHT OUTER JOIN ... ON clause in the FROM clause. The following query returns output with a right outer join from two tables: departments and employees. The join con... 2019-10-18, 2296🔥, 0💬

DML Commands Supported in MySQL
How Many SQL DML Commands Are Supported by "mysql" in MySQL? There are 4 SQL Data Manipulation Language (DML) commands that are supported by "mysql". They are listed below with short descriptions: "INSERT INTO tableName ..." - Inserts new data rows into the specified table. "DELETE FROM tableName ..... 2018-02-08, 2296🔥, 0💬

Use Existing Column Values in the SET Clause in MySQL
How To Use Existing Column Values in the SET Clause in MySQL? If a row matches the WHERE clause in a UPDATE statement, existing values in this row can be used in expressions to provide new values in the SET clause. Existing values are represented by column names in the expressions. The tutorial exer... 2018-01-13, 2296🔥, 0💬

What Are User Privileges in MySQL
What Are User Privileges in MySQL? MySQL offers many user privileges to control user accesses to different functions and data objects. Here are some commonly used privileges: ALL - All privileges. CREATE - Allows the user to use CREATE TABLE commands. ALTER - Allows the user to use ALTER TABLE comma... 2017-12-09, 2296🔥, 0💬

"CREATE VIEW/PROCEDURE" Statements - Creating a View and a Stored Procedure in SQL Server
How to create a view and a stored procedure using "CREATE VIEW/PROCEDURE" statements in SQL Server? This is the third tutorial of a quick lesson on creating login and configure users for databases with Transact-SQL statements. Granting a user access to a database involves three steps. First, you cre... 2016-11-27, 2296🔥, 0💬

Create an Oracle Database Manually in Oracle
How To Create an Oracle Database Manually in Oracle? Based on Oracle's Administrator Guide, there are 11 steps to create a database with the CREATE DATABASE statement: Step 1: Decide on Your Instance Identifier (SID) Step 2: Establish the Database Administrator Authentication Method Step 3: Create t... 2019-04-03, 2295🔥, 0💬

Drop an Existing View in Oracle
How To Drop an Existing View in Oracle? If you have an existing view, and you don't want it anymore, you can delete it by using the DROP VIEW statement as shown in the following script: DROP VIEW employee_department; View dropped.   ⇒ Understanding SQL DML Statements for Oracle ⇐ Create a New View ... 2020-02-07, 2294🔥, 0💬

Database Engine Tutorials from SQL Server 2005 Books Online
How to use Transact-SQL statements to access the database engine in SQL Server? Transact-SQL statements can be used to access the database engine directly. Here are some good tutorials provided by the SQL Server 2005 Books Online. See the SQL Server 2005 Tutorials &gt; Database Engine Tutorials ... 2016-11-27, 2294🔥, 0💬

Using CASE Expression in MySQL
How To Use CASE Expression in MySQL? There are 2 ways to use the CASE expression. The first way is to return one of the predefined values based on the comparison of a given value to a list of target values. The second way is to return one of the predefined values based on a list of conditions. Here ... 2018-03-24, 2293🔥, 0💬

Failed to Create a Database in MySQL
What Happens If You Do Not Have Privileges to Create Database in MySQL? If your MySQL server is provided by your Internet service company, your user account will most likely have no privilege to create new databases on the server. In that case, your CREATE DATABASE statement will fail. Here is an ex... 2017-11-11, 2293🔥, 0💬

Database Basics and Terminologies in MySQL
Where to find answers to frequently asked questions on Database Basics and Terminologies in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Database Basics and Terminologies in MySQL to help you review your knowledge. A short answer is prov... 2017-07-21, 2293🔥, 0💬

Show All Indexes of a given Table in MySQL
How To Get a List of Indexes of a Given Table in MySQL? If you want to see the index you have just created for an existing table, you can use the "SHOW INDEX FROM tableName" command to get a list of all indexes in a given table. The tutorial script below shows you a nice example: mysql&gt; SHOW ... 2018-02-14, 2292🔥, 0💬

Numeric Data Types in MySQL
What Are Numeric Data Types in MySQL? MySQL supports the following numeric data types: BIT(n) - An integer with n bits. BOOL same as BOOLEAN - Boolean values stored in 1 bit. TINYINT - A small integer stored in 1 byte. SMALLINT - A small integer stored in 2 bytes. MEDIUMINT - A medium integer stored... 2018-01-19, 2291🔥, 0💬

Create a Stored Procedure Interactively in Oracle
How To Create a Procedure Interactively in Oracle? If you want to create a stored procedure interactively, you can use the following steps: Open you connection name, like Local_XE. Right-click Procedures. Select Create PROCEDURE. The Create Procedure window shows up. Enter Name as: Hello Click OK. T... 2019-01-12, 2290🔥, 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, 2290🔥, 0💬

Sort Query Output in Descending Order in Oracle
How To Sort Query Output in Descending Order in Oracle? If you want to sort a column in descending order, you can specify the DESC keyword in the ORDER BY clause. The following SELECT statement first sorts the department in descending order, then sorts the salary in ascending order: SQL&gt; SELE... 2019-12-19, 2288🔥, 0💬

Using Group Functions in the SELECT Clause in MySQL
How To Use Group Functions in the SELECT Clause in MySQL? If group functions are used in the SELECT clause, they will be used on the rows that meet the query selection criteria, the output of group functions will be returned as output of the query. The following select statement returns 3 values cal... 2018-01-06, 2288🔥, 0💬

Declaring and Using Cursor Variables in SQL Server
How To Declare and Use Cursor Variables in SQL Server Transact-SQL? There are two ways to representing a cursor: 1. A cursor name - A static name representing a cursor object. A cursor name should be linked to a cursor object in the DECLARE statement. 2. A cursor variable name - A variable name poin... 2016-10-17, 2288🔥, 0💬

Rollback the Current Transaction in Oracle
How To Rollback the Current Transaction in Oracle? If you have used some DML statements updated some data objects, you find a problem with those updates, and you don't want those updates to be permanently recorded in the database, you can use the ROLLBACK statement. It will remove all the database c... 2019-09-04, 2287🔥, 0💬

Experiments of Data Locks in Oracle
How To Experiment a Data Lock in Oracle? If you want to have some experience with data locks, you can create two windows running two SQL*Plus sessions. In session 1, you can run a UPDATE statements to create a data lock. Before committing session 2, switch to session 2, and run a UPDATE statements o... 2019-08-08, 2287🔥, 0💬

Loop through a Cursor Variable in Oracle
How To Loop through a Cursor Variable in Oracle? Once a cursor variable is opened with a query statement, it will have the same attributes as a normal cursor and it can be used in the same way a normal cursor too. The following sample script shows you how to loop through a cursor variable: CREATE OR... 2018-07-18, 2287🔥, 0💬

Moving Database Physical Files to New Locations in SQL Server
How to move database physical files in SQL Server? If you want to move database physical files to a new location, you can use the "ALTER DATABASE" statements to bring the database offline, and link it to the files at the new location. The following tutorial gives you a good example: ALTER DATABASE F... 2016-11-20, 2287🔥, 0💬

<< < … 30 31 32 33 34 35 36 37 38 39 40 … > >>   ∑:1349  Sort:Date

General MySQL Oracle SQL Server