General MySQL Oracle SQL Server

<< < … 16 17 18 19 20 21 22 >   ∑:509  Sort:Date

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, 2202🔥, 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, 2202🔥, 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, 2200🔥, 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, 2189🔥, 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, 2188🔥, 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, 2183🔥, 0💬

Starting DTS Wizard
How To Start DTS Wizard? If you have installed DTS as part of the SQL Server 2000 Enterprise Manager tool properly, you should be able to start the DTS Wizard from the start menu: Click Start &gt; All Programs &gt; SQL Server &gt; Import and Export Data. The DST Wizard window will show u... 2024-01-31, 2180🔥, 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, 2176🔥, 0💬

PHP MSSQL - Creating an Identity Column
PHP MSSQL - How To Create an Identity Column? Many tables require an ID column to assign a unique ID number for each row in the table. For example, if you have a table to hold forum member profiles, you need an ID number to identify each member. To allow SQL Server to automatically assign a new ID n... 2024-02-09, 2175🔥, 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, 2171🔥, 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, 2171🔥, 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, 2171🔥, 0💬

mssql_fetch_array() - Looping through Result Set Objects
How To Loop through Result Set Objects using mssql_fetch_array()? If the returning output of a query statement is captured in a result set object, you can use mssql_fetch_array() to loop through each row in the output. The tutorial PHP script below shows you how to list tables in the database: &... 2024-03-23, 2165🔥, 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, 2162🔥, 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, 2158🔥, 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, 2140🔥, 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, 2138🔥, 0💬

Data Formats Supported by DTS
What Are the Data Formats Supported by DTS? As mentioned in the DTS manual, DTS wizard support many popular data source formats: dBase - *.dbf files created by dBase, a popular database application for PCs. ODBC drivers - Any data source that configured through ODBC drivers. Microsoft Access - *.mdb... 2024-01-19, 2123🔥, 0💬

What Is DTS
What Is DTS (Data Transformation Services)? DTS (Data Transformation Services) is a SQL Server database management wizard tool that allows you to import, export, and transform heterogeneous data. The DTS wizard tool guides you through the steps to import or export data between many popular data form... 2024-02-09, 2120🔥, 0💬

PHP ODBC - Searching Records by Keywords
PHP ODBC - How To Perform Key Word Search in Tables? The simplest way to perform key word search is to use the SELECT statement with a LIKE operator in the WHERE clause. The LIKE operator allows you to match a text field with a keyword pattern specified as '%keyword%', where (%) represents any numbe... 2024-05-05, 2119🔥, 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, 2115🔥, 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, 2114🔥, 0💬

PHP MSSQL - Dropping an Existing Table
PHP MSSQL - How To Drop an Existing Table? If you need to delete a table created before, you can run the DROP 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('FyiCenterData ... 2024-03-07, 2098🔥, 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, 2096🔥, 0💬

<< < … 16 17 18 19 20 21 22 >   ∑:509  Sort:Date

General MySQL Oracle SQL Server