General MySQL Oracle SQL Server

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

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

Giving Privileges at the Database Level in MySQL
How To Grant User Privileges at the Database Level in MySQL? If you want to grant a user privilege at the database level, you can use the "GRANT privilegeName ON databaseName.* TO userName" command. The argument "databasename.*" in the command stands for all tables in the specified database. The fol... 2017-08-21, 2158🔥, 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, 2157🔥, 0💬

Adding More Data to the Test Table in MySQL
How To Add More Data to the Testing Table in MySQL? If you want to continue with other tutorial exercises in this FAQ collection, you need to add more data to the testing table. Follow the script below to add a new column and: mysql&gt; ALTER TABLE fyi_links ADD COLUMN tag VARCHAR(8); mysql&... 2017-11-02, 2156🔥, 0💬

SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
A collection of 17 FAQs on using PHP MSSQL 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; ... 2024-03-07, 2155🔥, 0💬

Counting Groups Returned from GROUP BY in MySQL
How To Count Groups Returned with the GROUP BY Clause in MySQL? If you use the COUNT(*) function on groups returned with the GROUP BY clause, it will count the number of rows within each group, not the number of groups. If you want to count the number of groups, you can put the GROUP BY query into a... 2017-12-21, 2155🔥, 0💬

Checking Your PHP Installation
How To Check Your PHP Installation? PHP provides two execution interfaces: Command Line Interface (CLI) and Common Gateway Interface (CGI). If PHP is installed in the \php directory on your system, you can try this to check your installation: Run "\php\php -v" command to check the Command Line Inter... 2024-04-29, 2154🔥, 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, 2150🔥, 0💬

Joining Two Tables in a Single Query in SQL Server
How To Join Two Tables in a Single Query in SQL Server? 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 th... 2016-10-30, 2150🔥, 0💬

What Are Triggers in SQL Server
What Are Triggers in SQL Server? A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. A trigger is really an event handler. SQL Server allows users to create triggers (event handlers) for 3 types of events: DML Event - Occurs when a... 2016-10-25, 2149🔥, 0💬

mssql_field_name() - Retrieve Field Names
How To List All Field Names in the Result Set using mssql_field_name()? The result set object returned by a SELECT statement also contains column (field) names, lengths and types. You can use mssql_field_name(), mssql_field_length() and mssql_field_type() to get those information. The tutorial exerc... 2024-03-23, 2146🔥, 0💬

"DROP FUNCTION" - Dropping an Existing User Defined Function in SQL Server
How To Drop an Existing User Defined Function in SQL Server Transact-SQL? If you have an existing user defined function that you don't want to use it anymore, you should delete it from the SQL Server by using the "DROP FUNCTION" statement as shown in the tutorial example below: USE FyiCenterData; GO... 2016-12-24, 2145🔥, 0💬

Assign Names to Query Output Columns in MySQL
How To Name Query Output Columns in MySQL? Each column in the query output has a default name. If you don't like the default name, you can specify a new name for any column in the query output by using the AS clause. The following statement shows you a good example: mysql&gt; SELECT tag AS Categ... 2017-09-28, 2144🔥, 0💬

Assigning NULL Values to Variables or Columns in SQL Server
How To Assign NULL Values to Variables or Columns in SQL Server Transact-SQL? The rule for assigning NULL values to variables or table columns is simple: Use keyword "NULL" directly as normal values. "NULL" can be used in SET statements to assign NULL values to variables. "NULL" can be used in SET c... 2017-02-05, 2144🔥, 0💬

Simplest Way To Create New Databases in SQL Server
What is the simplest way to create a new database in SQL Server? The simplest way to create a new database is to use the "CREATE DATABASE" statement with this syntax: CREATE DATABASE database_name For example, run this statement: CREATE DATABASE FyiCenterData GO A new database called "FyiCenterData"... 2016-11-24, 2144🔥, 0💬

Writing Inner Joins with the WHERE Clause in SQL Server
How To Write an Inner Join with the WHERE Clause in SQL Server? If you don't want to use the INNER JOIN ... ON clause to write an inner join, you can put the join condition in the WHERE clause as shown in the following query example: SELECT l.id, l.url, r.comment FROM fyi_links l, fyi_rates r WHERE ... 2016-10-29, 2143🔥, 0💬

PHP ODBC - Updating Existing Rows in a Table
PHP ODBC - How To Update Existing Rows in a Table? Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row. The following sample script updates one row with two new values: &lt;?php $con = odbc_connect('FYI_SQL_SERVER', 'sa','FYIcenter');$sq... 2024-05-29, 2142🔥, 0💬

Turning on the MSSQL API Module
How to Turn on the MSSQL API Module? If you want to access SQL Server database with PHP scripts, the first thing you need to do is to turn on the MSSQL API Module as shown in this tutorial: 1. Prepare a single line script to test the MSSQL API Module: &lt;?php mssql_connect('LOCALHOST','sa' ,'FYI... 2024-04-14, 2141🔥, 0💬

"ALTER TRIGGER" - Modifying Existing Triggers in SQL Server
How To Modify Existing Triggers using "ALTER TRIGGER" in SQL Server? If you want to make changes to an existing trigger, you could use the "ALTER TRIGGER" statements to refine the trigger again. The tutorial exercise below shows you how to modify the trigger defined in a previous tutorial: USE FyiCe... 2016-10-24, 2141🔥, 0💬

"OPEN" - Executing the Query of a Cursor in SQL Server
How To Execute the Cursor Queries with "OPEN" Statements in SQL Server Transact-SQL? Once a cursor is declared, you need to execute the query attached to the cursor so that the result set returned from the query can be accessed through the cursor. To execute the cursor query, you should use the OPEN... 2016-10-17, 2141🔥, 0💬

odbc_tables() - Listing All Tables in the Database
How To List All Tables in the Database using odbc_tables()? If you want to get a list of all tables in the database, you can use the odbc_tables() function, which can actually be used to list all tables and views in the database. The syntax of odbc_tables() is: $result_set = odbc_tables($connection_... 2024-07-11, 2138🔥, 0💬

Deleting an Existing Row with DELETE Statements in SQL Server
How To Delete an Existing Row with DELETE Statements in SQL Server? If you want to delete an existing row from a table, you can use the DELETE statement with a WHERE clause to identify that row. Here is good sample of DELETE statements: -- insert a row for this test INSERT INTO fyi_links (url, id) V... 2016-10-30, 2138🔥, 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, 2136🔥, 0💬

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

General MySQL Oracle SQL Server