General MySQL Oracle SQL Server

<< < … 36 37 38 39 40 41 42 43 44 45 46 … > >>   ∑:1360  Sort:Date

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, 2578🔥, 0💬

Run the Anonymous Block Again in Oracle
How To Run the Anonymous Block Again in Oracle? If you have an anonymous block defined in your session, you can run it any time by using the "/" command as shown in the following script: SQL&gt; set serveroutput on; SQL&gt; begin 2 dbms_output.put_line('This is a PL/SQL FAQ.'); 3 end; 4 / Th... 2018-10-30, 2578🔥, 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, 2577🔥, 0💬

Experiment with Dead Locks in MySQL
How To Experiment Dead Locks in MySQL? If you want to have some experience with dead locks, you can create two windows running two mysql transactions in two sessions at the REPEATABLE READ transaction isolation level. Then run some UPDATE statements as shown in the tutorial exercise below: (session ... 2017-07-21, 2577🔥, 0💬

Define a Variable to Match Column Data Type in Oracle
How To Define a Variable to Match a Table Column Data Type in Oracle? If you have a table, and want to define some variables to have exactly the same data types as some columns in that table, you can use table_name.column_name%TYPE as data types to define those variables. The tutorial sample below s... 2018-08-14, 2575🔥, 0💬

Retrieving the Last Sequence ID in MySQL
How To Get the Last ID Assigned by MySQL in MySQL? If you use an ID column with AUTO_INCREMENT attribute, you can use the mysql_insert_id() function to get the last ID value assigned by the MySQL server, as shown in the sample script below: &lt;?php include "mysql_connection.php"; $sql = "INSERT... 2017-09-12, 2575🔥, 0💬

CASE - Conditional Expressions in SQL Server
What Are Conditional Expressions in SQL Server Transact-SQL? A conditional expression returns one of the given expressions based a specific condition. SQL Server 2005 offers the CASE operator to present a conditional expression with two syntaxes: 1. CASE with simple conditions CASE test_value WHEN v... 2017-01-29, 2575🔥, 0💬

Define the ID Column as Auto-Incremented in MySQL
How To Define the ID Column as Auto-Incremented in MySQL? Many tables require an ID column to assign a unique ID number for each row in the table. For example, if you have a table to hold forum member profiles, you need an ID number to identify each member. To allow MySQL server to automatically ass... 2017-09-12, 2574🔥, 0💬

Report View in SQL Developer in Oracle
What Is the Reports View in Oracle SQL Developer in Oracle? The Reports view lets you browse database information that organized by the server as special views. Information can be browsed include: Database parameters Storage information Session information Cursors Data objects User accounts Security... 2018-10-08, 2573🔥, 0💬

Time-Only DATETIME Values in SQL Server Transact-SQL
What Happens If Time-Only Values Are Provided for DATETIME variables in SQL Server Transact-SQL? If only time value is provided in a DATETIME variable, the SQL Server will pad the date value with a zero, representing the base date, January 1, 1900. The tutorial exercise below gives you some good exa... 2017-04-08, 2572🔥, 0💬

Working with NULL Values in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Working with NULL Values in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Working with NULL Values in SQL Server Transact-SQL. Clear explanations and tutorial exerci... 2017-02-08, 2572🔥, 0💬

Run Queries on External Tables in Oracle
How To Run Queries on External Tables in Oracle? If you have an external table defined as a text file with the ORACLE_LOADER driver, you can add data to the text file, and query the text file through the external table. By default, data fields in the text file should be terminated by ','. The tutori... 2016-10-15, 2572🔥, 0💬

System Defined User Roles in Oracle
What Are the System Predefined User Roles in Oracle? Oracle 10g XE comes with 3 predefined roles: CONNECT - Enables a user to connect to the database. Grant this role to any user or application that needs database access. RESOURCE - Enables a user to create certain types of schema objects in his own... 2019-07-30, 2571🔥, 0💬

Query with a Full Outer Join in MySQL
How To Write a Query with a Full Outer Join in MySQL? There is no way to do full outer join in MySQL. It does not support this feature at the current MySQL release.   ⇒ Inner Join with the WHERE Clause in MySQL ⇐ Query with a Right Outer Join in MySQL ⇑ SELECT Statements with JOIN and Subqueries in... 2017-09-28, 2570🔥, 0💬

Creating Stored Procedures with Parameters in SQL Server
How To Create Stored Procedures with Parameters in SQL Server Transact-SQL? Very often, you need to create a stored procedure with one or more parameters. You only supply values to those parameters at the time of executing the stored procedure. Stored procedures with parameters can be created with t... 2017-01-05, 2570🔥, 0💬

Getting a List of All Databases on the Server in SQL Server
How to get a list all databases on the SQL server in SQL Server? If you don't remember database names you have created, you can get a list of all databases on the server by query the "sys.databases" view as shown in this tutorial example: CREATE DATABASE FyiCenterData GO SELECT name, database_id, cr... 2016-11-24, 2570🔥, 0💬

PHP ODBC - odbc_fetch_array() - Looping through Returning Rows
PHP ODBC - How To Loop through Returning Rows? The best way to query tables and loop through returning rows is to run a SELECT statement with the odbc_exec() function, catch the returning object as a result set, and loop through the result with odbc_fetch_array() function in a while loop as shown in... 2024-05-29, 2567🔥, 0💬

What Is SQL Standard in MySQL
What Is SQL Standard in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation. SQL became an ANSI standard, called SQL-87, in 1986. ISO made a major revision, called SQL-92, in 1992. The latest r... 2018-04-21, 2567🔥, 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, 2567🔥, 0💬

Returning the Second 5 Rows from a Query in SQL Server
How To Return the Second 5 Rows in SQL Server? If you want to display query output in multiple pages with 5 rows per page, and the visitor wants to see the output for the second page, you need to display query output from row 6 to row 10. If you are using MySQL server, you can use the "LIMIT startRo... 2016-10-29, 2567🔥, 0💬

Transaction Committed when DDL Statement Executed in MySQL
What Happens to the Current Transaction If a DDL Statement Is Executed in MySQL? If a DDL statement is executed, the current transaction will be committed and ended. All the database changes made in the current transaction will become permanent. This is called an implicit commit by a DDL statement. ... 2016-10-17, 2567🔥, 0💬

Define an Explicit Cursor in Oracle
How To Define an Explicit Cursor in Oracle? An explicit cursor must be defined in the declaration part of a procedure or function with the CURSOR ... IS statement as shown in the following sample script: DECLARE CURSOR c_list IS SELECT * FROM countries; CURSOR t_list IS SELECT * FROM employees WHERE... 2018-07-22, 2566🔥, 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, 2565🔥, 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, 2565🔥, 0💬

<< < … 36 37 38 39 40 41 42 43 44 45 46 … > >>   ∑:1360  Sort:Date

General MySQL Oracle SQL Server