General MySQL Oracle SQL Server

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

Experiment with Data Locks in MySQL
How To Experiment Data Locks in MySQL? If you want to have some experience with data locks, you can create two windows running two mysql transactions in two sessions. In session 1, you can run a UPDATE statement with REPEATABLE READ transaction isolation level to create an exclusive lock. Before com... 2017-04-28, 2252🔥, 0💬

Using IN Conditions in MySQL
How To Use IN Conditions in MySQL? An IN condition is single value again a list of values. It returns TRUE, if the specified value is in the list. Otherwise, it returns FALSE. Some examples are given in the tutorial exercise below: SELECT 3 IN (1,2,3,4,5) FROM DUAL; 1 SELECT 3 NOT IN (1,2,3,4,5) FRO... 2018-03-28, 2251🔥, 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, 2251🔥, 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, 2251🔥, 0💬

Differences of CHAR and NCHAR in SQL Server Transact-SQL
What Are the Differences between CHAR and NCHAR in SQL Server Transact-SQL? Both CHAR and NCHAR are fixed length data types in Transact-SQL. But they have the following main differences: CHAR stores characters based on the code page with 1 byte per character most of the time. NCHAR stores characters... 2017-04-04, 2251🔥, 0💬

Concatenating Two Character Strings in SQL Server
How To Concatenate Two Character Strings Together in SQL Server Transact-SQL? Concatenating two character strings together is most commonly used string operation. SQL Server 2005 allows to concatenate two character strings into a single string with the (+) operator. The following tutorial exercise s... 2017-03-11, 2250🔥, 0💬

What Is a Table in SQL Server
What is a table in SQL Server? A table in database is a data object used to store data. Tables have the following features: Data is stored in a table with a structure of rows and columns. Columns must be pre-defined with names, types and constrains. A table object may have other associated data obje... 2016-11-20, 2250🔥, 0💬

Difference Between Clustered and Non-Clustered Indexes in SQL Server
What Is the Difference Between Clustered and Non-Clustered Indexes in SQL Server? SQL Server 2005 supports two types of indexes: clustered index and non-clustered index. Here are the main differences between them: One table can only have only one clustered index. One table can only have many non-clu... 2016-11-13, 2250🔥, 0💬

Syntaxes of Creating Table-Valued Functions in SQL Server
How Many Ways to Create Table-Valued Functions in SQL Server Transact-SQL? SQL Server supports two syntaxes of creating table-valued functions: 1. Inline Table-valued Functions - A table-valued function created with a single SELECT statement: CREATE FUNCTION function_name( @parameter_1 data_type, @p... 2016-12-18, 2249🔥, 0💬

Using Table Alias Names in MySQL
How To Define and Use Table Alias Names in MySQL? When column names need to be prefixed with table names, you can define table alias name and use them to prefix column names as shown in the following select statement: mysql&gt; SELECT l.id, l.url, r.comment FROM fyi_links l INNER JOIN fyi_rates ... 2017-12-31, 2247🔥, 0💬

"IS NULL" - Testing NULL Values in SQL Server
How To Test NULL Values Properly in SQL Server Transact-SQL? From previous tutorials, you learned that comparing expressions with NULL will always result NULL. So you can not use comparison operators to test if an expression represents a NULL value or not. To test expressions for NULL values, you sh... 2017-02-03, 2247🔥, 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, 2247🔥, 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, 2246🔥, 0💬

Build WHERE Criteria with Web Form Data in MySQL
How To Build WHERE Criteria with Web Form Search Fields in MySQL? If your PHP script is linked to a Web form which takes search key words for multiple data fields. For example, your Web form asks your visitor to search for Website links with a URL search field, a Website title search field, a descri... 2017-06-23, 2246🔥, 0💬

Add Another Datafile to a Tablespace in Oracle
How To Add Another Datafile to a Tablespace in Oracle? If you created a tablespace with a data file a month ago, now 80% of the data file is used, you should add another data file to the tablespace. This can be done by using the ALTER TABLESPACE ... ADD DATAFILE statement. See the following sample s... 2019-04-09, 2245🔥, 0💬

Use DML Statements in PL/SQL in Oracle
Can DML Statements Be Used in PL/SQL in Oracle? Yes, you can run almost any DML statements in PL/SQL directly. To manipulate Oracle database data you can include INSERT, UPDATE, and DELETE statements, directly in PL/SQL programs, without any special notation, as shown in the following sample code: (... 2018-10-13, 2245🔥, 0💬

"DROP PROCEDURE" - Dropping an Existing Procedure in SQL Server
How To Drop an Existing Stored Procedure in SQL Server Transact-SQL? If you have an existing procedure that you don't want to use it anymore, you should delete it from the SQL Server by using the "DROP PROCEDURE" statement as shown in the tutorial example below: USE FyiCenterData; GO DROP PROCEDURE ... 2017-01-05, 2245🔥, 0💬

Deleting an Existing Database in MySQL
How To Drop an Existing Database in MySQL? If want to drop an existing database from the MySQL server, you can use the DROP DATABASE statement. Here is a good example of dropping an existing database: $con = mysql_connect('localhost:8888' ,'dev', 'iyf'); $sql = 'DROP DATABASE fyi'; if (mysql_query($... 2017-10-23, 2244🔥, 0💬

Transaction Roll Back when Session Ended in MySQL
What Happens to the Current Transaction If the Session Is Ended in MySQL? If a session is ended, the current transaction in that session will be rolled back and ended. All the database changes made in the current transaction will be removed. This is called an implicit rollback when session is ended.... 2017-08-03, 2244🔥, 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, 2244🔥, 0💬

Ways to Join Two Tables in a Single Query in Oracle
How To Join Two Tables in a Single Query in Oracle? Two tables can be joined together in a query in 4 ways: Inner Join: Returns only rows from both tables that satisfy the join condition. Left Outer Join: Returns rows from both tables that satisfy the join condition, and the rest of rows from the fi... 2019-10-27, 2243🔥, 0💬

Restrictions on External Table Columns in Oracle
What Are the Restrictions on External Table Columns in Oracle? When creating external table columns, you need to watch out some restrictions: "PRIMARY KEY" is not allowed. "NOT NULL" is not allowed. "DEFAULT value" is not allowed.   ⇒ What Is a Directory Object in Oracle ⇐ Load Data through Externa... 2016-11-27, 2243🔥, 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, 2242🔥, 0💬

Recover a Dropped Table in Oracle
How To Recover a Dropped Table in Oracle? If you accidentally dropped a table, can you recover it back? The answer is yes, if you have the recycle bin feature turned on. You can use the FLASHBACK TABLE ... TO BEFORE DROP statement to recover a dropped table from the recycle bin as shown in the follo... 2019-05-14, 2242🔥, 0💬

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

General MySQL Oracle SQL Server