General MySQL Oracle SQL Server

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

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, 2728🔥, 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, 2727🔥, 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, 2726🔥, 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, 2724🔥, 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, 2714🔥, 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, 2701🔥, 0💬

Defining SQL Server 2005 as the DTS Data Source
How To Define SQL Server 2005 as the DTS Data Source? If you want to transform (export) data out of a SQL Server 2005 database table, you need to configure the DTS data source to connect the SQL Server 2005 server. The tutorial exercise below shows you how to connect to the local SQL Server 2005 ser... 2024-01-31, 2673🔥, 0💬

Preparing Data in Text Files for DTS to Import
How To Prepare Data in Text Files for DTS to Import? Sometimes you have data organized in rows and columns and stored in text files. You can import data from text files to SQL Server database tables using the DTS wizard. But you need to prepare data text files with the following questions in mind: W... 2024-01-19, 2667🔥, 0💬

mssql_select_db() - Selecting an Exiting Database
How To Select an Exiting Database using mssql_select_db()? The first thing after you have created a connection object to the SQL Server is to select the database where your tables are located, by using the mssql_select_db() function. If your MSSQL server is offered by your Web hosting company, they ... 2024-04-07, 2666🔥, 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, 2664🔥, 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, 2658🔥, 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, 2653🔥, 0💬

PHP MSSQL - Including Text Values in SQL Statements
PHP MSSQL - 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-02-18, 2652🔥, 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, 2650🔥, 0💬

Defining Text Files as the DTS Data Source
How To Define Text Files as the DTS Data Source? If your data text file is ready to import, you can start the DTS wizard and define the text file as the data source following this tutorial: 1. Start the DTS wizard and click Next. The data source window shows up. 2. Select "Text File" as the Data Sou... 2024-01-19, 2630🔥, 0💬

Copying a Table from Source to Destination
How To Copy a Table from Source to Destination? If the DTS data source is set to a SQL Server, you have two options to transform data from source to destination: Copy all rows and columns of a table or view. Generating data by a SELECT query statement. This tutorial continues from previous tutorials... 2024-01-31, 2627🔥, 0💬

PHP MSSQL - Making Columns to Take NULL
PHP MSSQL - How To Make a Column Nullable? Based on the testing result from the previous tutorial you can find out that there is a big difference in the column definition when running CREATE TABLE statement with mssql_query(): If CREATE TABLE is executed through mssql_query() and "NULL/NOT NULL" key... 2024-03-07, 2624🔥, 0💬

PHP MSSQL - mssql_fetch_array() - Looping through Returning Rows
PHP MSSQL - 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 mssql_query() function, catch the returning object as a result set, and loop through the result with mssql_fetch_array() function in a while loop as show... 2024-02-28, 2609🔥, 0💬

JSON_STORAGE_FREE() - Free Space in JSON Value
How to obtain the free space size in a JSON table column using the JSON_STORAGE_FREE() function? JSON_STORAGE_FREE(json) is a MySQL built-in function that returns the free space size in a JSON table column. Free space occurs when JSON table column is partially updated with less data. For example: CR... 2024-12-18, 2603🔥, 0💬

DENSE_RANK() - Density Rank of Sorted Values
How to calculate the density rank of the sorting field expression in the current result set window using the DENSE_RANK() function? DENSE_RANK() is a MySQL built-in window function that calculates the density rank of the sorting field expression in the current result set window. For example: SELECT ... 2024-09-28, 2603🔥, 0💬

PHP MSSQL - Returning Result Set Objects
PHP MSSQL - What Is a Result Set Object Returned by mssql_query()? A result set object is a logical representation of data rows returned by mssql_query() 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 ... 2024-02-28, 2603🔥, 0💬

MySQL Functions on Character String Values
Where to find reference information and tutorials on MySQL database functions on string values? I want to know how to use SUBSTRING(), REPLACE() and other character string related functions. Here is a collection of reference information and tutorials on MySQL database functions on string values comp... 2023-11-10, 2591🔥, 0💬

PHP MSSQL - Updating Existing Rows in a Table
PHP MSSQL - 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 = mssql_connect('LOCALHOST','sa' ,'FYIcenter');mssql_... 2024-02-18, 2586🔥, 0💬

PHP MSSQL - Deleting Existing Rows in a Table
PHP MSSQL - How To Delete Existing Rows in a Table? 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 $con = mssql_connect('LOCALHOST','sa' ,'FYIcenter');mssql_select_db('FyiCe... 2024-02-18, 2582🔥, 0💬

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

General MySQL Oracle SQL Server