General MySQL Oracle SQL Server

<< < … 48 49 50 51 52 53 54 55 56 57 > >>   ∑:1360  Sort:Date

Configuring and Testing ODBC DSN Settings
How To Configure and Test ODBC DSN Settings? Continue from the previous tutorial. Click Next after you have finished changing the port number. The ODBC Data Source Administrator will try to connect to the SQL server through the specified port number and login information. If the connection is succes... 2024-07-25, 2282🔥, 0💬

odbc_connect() - Connecting to a SQL Server through an ODBC DSN
How To Connect to a SQL Server using odbc_connect()? If you have an ODBC DSN (Data Source Name) created linking to a SQL Server, you are ready to connect to the SQL Server through the DSN with ODBC functions. There is no changes needed in the php.ini configuration file. The tutorial script below sho... 2024-07-11, 2279🔥, 0💬

NULL Values Involved in String Operations in SQL Server
What Happens If NULL Values Are Involved in String Operations in SQL Server Transact-SQL? If NULL values are involved in string operations, the result will be string NULL values. The following tutorial script shows you some good examples: SELECT 'FyiCenter'+NULL; GO ---------- NULL SELECT LEN(NULL);... 2017-02-05, 2279🔥, 0💬

Security Model Used in SQL Server 2005 in SQL Server
What Is the Security Model Used in SQL Server 2005 in SQL Server? SQL Server 2005 uses a very standard security model involves 3 concepts: Securables - Entities representing resources that need to be secured. For example, a database table is a securable. Principals - Entities representing users that... 2016-10-20, 2273🔥, 0💬

PHP MSSQL - Inserting Data into an Existing Table
PHP MSSQL - How To Insert Data into an Existing Table? If you want to insert a row of data into an existing table, you can use the INSERT INTO statement as shown in the following sample script: &lt;?php $con = mssql_connect('LOCALHOST','sa' ,'FYIcenter');mssql_select_db('FyiCenterData ',$con); $... 2024-03-07, 2272🔥, 0💬

PHP MSSQL - Creating a New Table
PHP MSSQL - How To Create a New Table? If you want to create a table in the SQL Server database, you can run the CREATE TABLE SQL statement using the mssql_query() function, as shown in the following sample script: &lt;?php $con = mssql_connect('LOCALHOST','sa' ,'FYIcenter');mssql_select_db('Fyi... 2024-03-07, 2268🔥, 0💬

Installing DTS on Windows XP Systems
How To Install DTS (Data Transformation Services) on Windows XP Systems? SQL Server 2000 is not supported on Windows XP systems, but you can still install DTS (Data Transformation Services) as client component your XP system. This allows you to continue to use DTS with SQL Server 2005, if you don't ... 2024-01-31, 2268🔥, 0💬

Inserting Rows with a SELECT Statement in MySQL
How To Insert Multiple Rows with a SELECT Statement in MySQL? If want to insert rows into a table based on data rows from other tables, you can use a sub-query inside the INSERT statement as shown in the following script example: &lt;?php include "mysql_connection.php"; $sql = "INSERT INTO fyi_l... 2017-09-20, 2268🔥, 0💬

"AS" - Naming Query Output Columns in SQL Server
How To Name Query Output Columns in SQL Server? 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: SELECT tag AS Category, YEAR... 2016-10-29, 2264🔥, 0💬

PHP ODBC - Computing Date and Time Differences
PHP ODBC - How To Display a Past Time in Days, Hours and Minutes? You have seen a lots of Websites are displaying past times in days, hours and minutes. If you want to do this yourself, you can use the DATEDIFF() SQL function The following tutorial exercise shows you how to use DATEDIFF() to present... 2024-05-05, 2256🔥, 0💬

PHP ODBC - Inserting Multiple Rows with a Subquery
PHP ODBC - How To Insert Multiple Rows with a subquery? If want to insert rows into a table based on data rows from other tables, you can use a subquery inside the INSERT statement as shown in the following script example: &lt;?php $con = odbc_connect('FYI_SQL_SERVER', 'sa','FYIcenter');$sql = "... 2024-05-29, 2249🔥, 0💬

Testing ODBC DSN Connection Settings
How To Test ODBC DSN Connection Settings? Assuming you have followed other FYIcenter.com tutorials and created an ODBC DSN called "FYI_SQL_SERVER", and planning to use it your PHP scripts, you should test this ODBC connection first as shown in this tutorial: 1. Go to Control Panel &gt; Administr... 2024-07-11, 2245🔥, 0💬

PHP ODBC - Returning Result Set Objects
PHP ODBC - What Is a Result Set Object Returned by odbc_exec()? A result set object is a logical representation of data rows returned by odbc_exec() function on SELECT statements. Every result set object has an internal pointer used to identify the current row in the result set. Once you get a resul... 2024-05-29, 2241🔥, 0💬

Returning Result from Query with MSSQL Connection
How To Receive Returning Result from a Query? When you execute a SQL SELECT statement with the mssql_query() function, you can capture the returning result with a result set object with the following syntax: $result_set = mssql_query($sql_statement); #- The returning value could be a Boolean value F... 2024-03-23, 2231🔥, 0💬

PHP MSSQL - Inserting Data with NULL Values
PHP MSSQL - How To Insert Data with NULL Values? There are two ways to provide NULL value to a column in an INSERT statement: Include the column in the statement, but specify keyword NULL as the value. Exclude the column from the statement. The following tutorial exercise inserts two rows. Both of t... 2024-02-28, 2228🔥, 0💬

mssql_query() - Executing SQL Statements
How To Execute a SQL Statement using mssql_query()? Once you have created a connection object, you can use the mssql_query() function to send a SQL statement to the SQL Server linked to the connection object for execution. Here is a simple PHP script that creates a new schema and a new table: &l... 2024-04-07, 2222🔥, 0💬

Turning Off PHP Warning Messages for MSSQL Connection
How To Turn Off Warning Messages during PHP Execution? If don't want see warning messages generated from the PHP engine when executing PHP scripts, you can change the error_reporting setting in the php.ini configuration file. Open php.ini and change the following lines: ;error_reporting = E_ALL &... 2024-03-23, 2218🔥, 0💬

"DROP TRIGGER" - Deleting Existing Triggers in SQL Server
How To Delete Existing Triggers using "DROP TRIGGER" in SQL Server? If you don't want to use a trigger any more, you should delete it from the database by using the "DROP TRIGGER" statement as shown in tutorial example: USE FyiCenterData; GO DROP TRIGGER new_user; GO SELECT * FROM sys.triggers GO na... 2016-10-24, 2218🔥, 0💬

mssql_result() - Retrieve Field Values
How To Retrieve Field Values using mssql_result()? Once the result set is captured in an object, you can think of it as a "table" with rows and columns (fields). You can use mssql_result() to retrieve the value of any given row and column (field) with this formats: $value = mssql_result($res, $row, ... 2024-03-23, 2217🔥, 0💬

PHP MSSQL - Inserting Multiple Rows with a Subquery
PHP MSSQL - How To Insert Multiple Rows with a subquery? If want to insert rows into a table based on data rows from other tables, you can use a subquery inside the INSERT statement as shown in the following script example: &lt;?php $con = mssql_connect('LOCALHOST','sa' ,'FYIcenter');mssql_selec... 2024-02-28, 2210🔥, 0💬

PHP MSSQL - Including Date and Time Values in SQL Statements
PHP MSSQL - How To Include Date and Time Values in SQL Statements? If you want to provide date and time values in a SQL statement, you should write them in the format of "yyyy-mm-dd hh:mm:ss", and quoted with single quotes ('). The tutorial exercise below shows you two INSERT statements. The first o... 2024-02-18, 2210🔥, 0💬

PHP MSSQL - Computing Date and Time Differences
PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes? You have seen a lots of Websites are displaying past times in days, hours and minutes. If you want to do this yourself, you can use the DATEDIFF() SQL function The following tutorial exercise shows you how to use DATEDIFF() to presen... 2024-02-18, 2200🔥, 0💬

What Is a Subquery in a SELECT Query Statement in SQL Server
What Is a Subquery in a SELECT Query Statement in SQL Server? A subquery is a SELECT statement used as part of the selection criteria of the main SELECT statement. The subquery specified in the WHERE clause will be evaluated repeated on each row of the selection base table. The output of the subquer... 2016-10-29, 2196🔥, 0💬

MySQL Functions for Miscellaneous Purposes
Where to find reference information and tutorials on MySQL database functions for Miscellaneous Purposes? I want to know how to use CAST(), SLEEP() and other miscellaneous functions. Here is a collection of reference information and tutorials on MySQL database functions for Miscellaneous Purposes co... 2026-03-22, 2195🔥, 0💬

<< < … 48 49 50 51 52 53 54 55 56 57 > >>   ∑:1360  Sort:Date

General MySQL Oracle SQL Server