General MySQL Oracle SQL Server

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

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, 2076🔥, 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, 2075🔥, 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, 2072🔥, 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, 2067🔥, 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, 2050🔥, 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, 2048🔥, 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, 2047🔥, 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, 2047🔥, 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, 2038🔥, 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, 2033🔥, 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, 2031🔥, 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, 2030🔥, 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, 2028🔥, 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, 2026🔥, 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, 2018🔥, 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, 2018🔥, 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, 2014🔥, 0💬

PHP ODBC - Query Multiple Tables Jointly
PHP ODBC - How To Query Multiple Tables Jointly? If you want to query information stored in multiple tables, you can use the SELECT statement with a WHERE condition to make an inner join. Assuming that you have 3 tables in a forum system: "users" for user profile, "forums" for forums information, an... 2023-12-30, 2013🔥, 0💬

PHP MSSQL - Query Multiple Tables Jointly
PHP MSSQL - How To Query Multiple Tables Jointly? If you want to query information stored in multiple tables, you can use the SELECT statement with a WHERE condition to make an inner join. Assuming that you have 3 tables in a forum system: "users" for user profile, "forums" for forums information, a... 2024-02-09, 2003🔥, 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, 2002🔥, 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, 1995🔥, 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, 1993🔥, 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, 1982🔥, 0💬

SQL Server FAQs - Introduction to DTS (Data Transformation Services)
A collection of 10 FAQs on DTS (Data Transformation Services). Clear explanations and tutorial exercises are provided on using DTS to import data to SQL Server and export data from SQL Server; exporting tables to MS Excel files; importing tables from text files. Topics included in this collections: ... 2024-02-09, 1979🔥, 0💬

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

General MySQL Oracle SQL Server