General MySQL Oracle SQL Server

<< < … 44 45 46 47 48 49 50 51 52 53 54 … > >>   ∑:1357  Sort:Date

IN - Testing Values Returned by a Subquery in SQL Server
How To Test Values Returned by a Subquery with the IN Operator in SQL Server Transact-SQL? Normally, the comparison operator IN is used against a list of specified values as in the format of: "test_value IN (value_1, value_2, ..., value_n)". But you can also replace the list of values by a subquery ... 2017-01-21, 2349🔥, 0💬

Commonly Used ODBC Functions in PHP
What Are Commonly Used ODBC Functions in PHP? If you look at the PHP 5 manual, you will see a group of functions listed under the ODBC Functions (Unified) section. The commonly used ODBC functions are: odbc_connect � Establish an OBDC connection. odbc_data_source � Returns information about a curren... 2024-03-17, 2348🔥, 0💬

Providing Column Names in INSERT Statements in SQL Server
How to provide column names in INSERT Statements in SQL Server? If you don't want to specify values for columns that have default values, or you want to specify values to columns in an order different than how they are defined, you can provide a column list in the INSERT statement. If a column is om... 2016-11-02, 2348🔥, 0💬

Index - Data Structure for Query Performance in Oracle
What Is an Index in Oracle? Index is an optional structure associated with a table that allow SQL statements to execute more quickly against a table. Just as the index in this manual helps you locate information faster than if there were no index, an Oracle Database index provides a faster access pa... 2019-05-10, 2347🔥, 0💬

Security Principals Used in SQL Server 2005 in SQL Server
What Are Security Principals Used in SQL Server 2005 in SQL Server? SQL Server 2005 supports several basic security principals located at different levels: Windows-Level Principals: Windows Local Login and Windows Network Domain Login - Used to control accesses to SQL Server instances. SQL Server-Le... 2016-10-20, 2347🔥, 0💬

Connecting MS Access to SQL Servers through ODBC
How To Connect MS Access to SQL Servers through ODBC? Once you got a DSN defined in the ODBC manager that connects to your SQL Server, you can connect a normal MS Access document to the Oracle server, and link an Access table to a SQL Server table. The tutorial below gives you a good example: Start ... 2024-03-17, 2343🔥, 0💬

Requirements to Use ODBC Connections in PHP
What Are the Requirements to Use ODBC Connections in PHP Scripts? If you are planning to use ODBC connections to access SQL Server databases in PHP scripts, you need to check the following requirements: The PHP engine must support ODBC functions. If you install PHP 5.2.2 from The PHP Group, the ODBC... 2024-03-17, 2342🔥, 0💬

Assign Data from a Deleted Row to Variables in Oracle
How To Assign Data of the Deleted Row to Variables in Oracle? If a DELETE statement is deleting a single row, you can assign column values of the deleted row to variables by using the RETURNING clause, which an extension of DELETE statements for PL/SQL. The tutorial script shows you how to do this: ... 2018-09-13, 2342🔥, 0💬

Retrieve Field Values from RECORD Variables in Oracle
How To Retrieve Values from Data Fields in RECORD Variables in Oracle? If a variable is a RECORD variable with data fields assigned values, you can retrieve those values out of its data fields by using fields names prefixed with variable name as "variable.field_name". Here is a sample script showing... 2018-09-01, 2342🔥, 0💬

Expressions with NULL Values in MySQL
What Happens If NULL Values Are Involved in Expressions in MySQL? If NULL values are used in expressions, the resulting values will be NULL values. In other words: Arithmetic expressions with NULL values result NULL values. Comparison expressions with NULL values result NULL values. Logical expressi... 2018-03-28, 2341🔥, 0💬

LIKE - Matching a Pattern in a Character String in SQL Server
What To Perform Pattern Match with the LIKE Operator in SQL Server Transact-SQL? Pattern match is a very important operation for search records base on character string columns. SQL Server 2005 offers the LIKE operator to perform pattern match operations in two formats: target_string LIKE pattern --... 2017-01-21, 2341🔥, 0💬

Server Daemon mysqld Administration in MySQL
Where to find answers to frequently asked questions on Server Daemon mysqld Administration in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Server Daemon mysqld Administration in MySQL. Clear answers are provided with tutorial exercises o... 2017-12-09, 2340🔥, 0💬

SQL Server FAQs - PHP ODBC Functions - Managing Tables and Data Rows
A collection of 14 FAQs on using PHP ODBC functions to connect to manage tables and data rows. Clear explanations and tutorial exercises are provided on creating tables; inserting multiple data rows; updating and deleting data rows; searching data from multiple tables; looping through result sets; w... 2024-06-03, 2339🔥, 0💬

Requirements on SQL Server Network Connections
What Are the Requirements on SQL Server Network Connections? By default, SQL Server 2005 Express Edition is installed only one connection protocol enabled: Shared Memory - SQL Server connection protocol for applications that are running on the same machine where the SQL Server is running. For exampl... 2024-08-06, 2337🔥, 0💬

UNION - Merging Outputs from Two Queries Together in SQL Server
How To Use UNION to Merge Outputs from Two Queries Together in SQL Server? If you have two queries that returns the same row fields, you can merge their outputs together with the UNION operator. The following tutorial exercise shows you how to use the UNION operator: SELECT * FROM fyi_links WHERE ta... 2016-10-26, 2337🔥, 0💬

DROP INDEX - Removing Existing Indexes in SQL Server
How To Drop Existing Indexes in SQL Server? For some reason, if you want remove an existing index, you can use the DROP INDEX statement with following syntax: CREATE INDEX table_name.index_name The tutorial exercise below shows you how to remove the index "fyi_links_id": USE FyiCenterData; GO SELECT... 2016-11-15, 2335🔥, 0💬

IN - Testing Value in a Value List in SQL Server
What To Test Value Lists with the IN Operator in SQL Server Transact-SQL? Sometimes you want to test a given value against a list of values. You can do this in a loop with the regular "equal" operator. But you can also use the special comparison operator IN to get it done with the following syntaxes... 2017-01-21, 2333🔥, 0💬

Group Functions in Query Statements in SQL Server
What Are Group Functions in Query Statements in SQL Server? Group functions are functions applied to a group of rows. Examples of group functions are: COUNT(*) - Returns the number of rows in the group. MIN(exp) - Returns the minimum value of the expression evaluated on each row of the group. MAX(ex... 2016-10-25, 2333🔥, 0💬

PHP ODBC - Including Text Values in SQL Statements
PHP ODBC - How To Include Text Values in SQL Statements? Text values in SQL statements should be quoted with single quotes ('). If the text value contains a single quote ('), it should be protected by replacing it with two single quotes (''). In SQL language syntax, two single quotes represents one ... 2024-05-05, 2330🔥, 0💬

SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution
A collection of 18 FAQs on connecting to MS SQL Server with PHP scripts. Clear explanations and tutorial exercises are provided on SQL Server connection; providing port number; selecting database; running SQL statements; checking execution errors; looping through query result; looping through result... 2024-04-29, 2330🔥, 0💬

Creating a New Table in a Given Schema in SQL Server
How To Create a New Table in a Given Schema in SQL Server? When you create a new table, you can specify in which schema you want this table to be located by prefixing the table name with the schema name. In the tutorial example below, a new table "test" is created in schema "fyi": USE FyiCenterData;... 2016-10-22, 2330🔥, 0💬

Use "WHILE" Loop Statements in Oracle
How To Use "WHILE" Loop Statements in Oracle? If you have a block of codes to be executed repeatedly based a condition, you can use the "WHILE ... LOOP" statement. Here is a sample script on WHILE statements: DECLARE total NUMBER; BEGIN total := 0; WHILE total &lt; 10 LOOP total := total+1; END ... 2018-07-13, 2327🔥, 0💬

Define Variables before Procedures and Functions in Oracle
What Is the Order of Defining Local Variables and Sub Procedures/Functions in Oracle? In the declaration part, you must define all local variables before defining any sub procedures or sub functions. See the following sample script: SQL&gt; CREATE OR REPLACE PROCEDURE WELCOME AS 2 SITE CHAR(80) ... 2018-03-18, 2327🔥, 0💬

Using Subqueries in the FROM Clause in MySQL
How To Use Subqueries in the FROM clause in MySQL? If you have a query returning many rows of data, and you want to perform another query on those rows, you can put the first query as a subquery in the FROM clause of the second query. A subquery used in this way become a temporary table, and you mus... 2017-12-21, 2326🔥, 0💬

<< < … 44 45 46 47 48 49 50 51 52 53 54 … > >>   ∑:1357  Sort:Date

General MySQL Oracle SQL Server