General MySQL Oracle SQL Server

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

Running SQL Server 2005 Books Online on Your Local System in SQL Server
How to run SQL Server 2005 Books Online on your local system in SQL Server? SQL Server 2005 Books Online can be accessed by a Web browser over the Internet. But you can also download it and read it on your local system. If you have downloaded and installed SQL Server 2005 Books Online package, you f... 2016-12-04, 2411🔥, 0💬

Create a Table Index in Oracle
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that one of the columns will be used often a search criteria, you can add an index for that column to in improve the search performance. To add an index, you can use the CREATE INDEX statement as shown in th... 2019-05-01, 2410🔥, 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, 2410🔥, 0💬

Run Stored Procedures Interactively in Oracle
How To Run a Stored Procedure Interactively in Oracle? If have an existing stored procedure and you want to run it interactively, the tutorial steps listed below will help you out: Open you connection name, like Local_XE. Open Procedures. Right-click the procedure name: HELLO. Select Run. The Run PL... 2019-01-12, 2408🔥, 0💬

Execute SQL Statements in MySQL
How To Execute a SQL Statement in MySQL? You can run any types of SQL statements through the mysql_query() function. It takes the SQL statement as a string and returns different types of data depending on the SQL statement type and execution status: Returning FALSE, if the execution failed. Returnin... 2017-10-23, 2408🔥, 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, 2408🔥, 0💬

Read Consistency in Oracle in Oracle
How Does Oracle Handle Read Consistency in Oracle? Oracle supports two options for you on how to maintain read consistency: READ WRITE (the default option), also called statement-level read consistency. READ ONLY, also called transaction-level read consistency.   ⇒ What Is a READ WRITE Transaction i... 2019-08-23, 2407🔥, 0💬

Testing DML Triggers in SQL Server
How To Test a DML Trigger in SQL Server? To test a DML trigger defined on a table, you just need to execute several INSERT, UPDATE and DELETE statements on that table as shown in this tutorial example: USE FyiCenterData; GO INSERT INTO fyi_users (name) VALUES ('FYI Admin'); GO Records are inserted, ... 2016-10-25, 2407🔥, 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, 2406🔥, 0💬

SQL Server Connection Tutorials
Where to find SQL Server Connection tutorials? I am having trouble to connect to my SQL Server. Here is a collection of tutorials, tips and FAQs on how to connect your client tools and client application programs to SQL server. SQL Server Connection Concepts SQL Server Connection Protocols SQL Serve... 2023-12-30, 2405🔥, 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, 2405🔥, 0💬

Ways to Start MySQL Server in MySQL
How To Start MySQL Server Daemon mysqld in MySQL? There are a number of ways to start MySQL server daemon, mysqld: Double click on the file name, mysqld.exe, in a file explorer window. This is an easy way to start the server. But you will not be able to specify any command line options. Enter "mysql... 2017-12-04, 2405🔥, 0💬

Connect to a Remote Server in Oracle
How To Connect to a Remote Server in Oracle? If you have an Oracle server running remotely on a network, and you know all the access information needed, you can following steps to connect your Oracle SQL Developer: Start Oracle SQL Developer Right-click on Connections Select New Database Connection ... 2018-10-08, 2404🔥, 0💬

Deleting Existing Rows in MySQL
How To Delete Existing Rows in a Table in MySQL? If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row. The following sample script deletes one row: &lt;?php include "mysql_connection.php"; $sql = "DELETE FROM fyi_links WHERE id = 1102... 2017-06-28, 2403🔥, 0💬

Use "FOR" Loop Statements in Oracle
How To Use "FOR" Loop Statements in Oracle? If you have a block of codes to be executed repeatedly over a range of values, you can use the "FOR ... LOOP" statement. Here is a sample script on FOR statements: DECLARE total NUMBER := 0; BEGIN FOR i IN 1..10 LOOP total := total + i; END LOOP; DBMS_OUTP... 2018-07-13, 2402🔥, 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, 2402🔥, 0💬

Data Types Supported in PL/SQL in Oracle
How Many Data Types Are Supported in Oracle? PL/SQL supports two groups of data types: SQL Data Types - All data types used for table columns. PL/SQL Special Data Types - Like BOOLEAN or PLS_INTEGER. The script below shows some data type examples: SQL&gt; set serveroutput on; SQL&gt; DECLARE... 2019-03-20, 2401🔥, 0💬

Managing Databases and Physical Files in SQL Server
Where to find answers to frequently asked questions on Managing Databases and Physical Files in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Databases and Physical Files in SQL Server. Clear answers are provided with tutori... 2016-11-24, 2400🔥, 0💬

CREATE CLUSTERED INDEX - Adding Clustered Indexes in SQL Server
How To Create a Clustered Index in SQL Server? If there is no primary key in a table, you can add one clustered index to that table with CREATE CLUSTERED INDEX statement. The tutorial exercise below shows you how to create a clustered index: USE FyiCenterData; GO -- Drop the old table, if needed DRO... 2016-11-13, 2400🔥, 0💬

UPDATE Subquery Returning No Rows in SQL Server
What Happens If the UPDATE Subquery Returns No Rows in SQL Server? If you use a subquery to assign new values in the SET clause in an UPDATE statement, and the subquery returns no rows for an outer row, SQL Server will provide a NULL value to the SET clause. The tutorial exercise below shows you a g... 2016-11-02, 2400🔥, 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, 2399🔥, 0💬

Loop through the Implicit Cursor in Oracle
How To Loop through Data Rows in the Implicit Curosr in Oracle? You use the FOR ... IN ... LOOP statement to loop through data rows in the implicit cursor as the following syntax: FOR row IN dml_statement LOOP (statement block with row.field) END LOOP; Here "row" is a local RECORD type variable with... 2018-07-22, 2398🔥, 0💬

SQL Server Connection Concepts
Where to find answers to frequently asked questions on SQL Server Connection Concepts? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Server Connectivity Concepts. SQL Server Connection Protocols SQL Server TCP/IP Connection Info   ⇒ SQL Serv... 2024-08-14, 2397🔥, 0💬

Renaming Database Names in SQL Server
How to rename databases in SQL Server? If don't like the name of a database, you can change it by using the "ALTER DATABASE" statement with the following syntax: ALTER DATABASE database_name MODIFY NAME = new_database_name The tutorial example below shows you how change the database name from "FyiCe... 2016-11-24, 2397🔥, 0💬

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

General MySQL Oracle SQL Server