Collections:
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; working with dates. Topics included in this collections:
PHP MSSQL - Creating a New Table
PHP MSSQL - Dropping an Existing Table
PHP MSSQL - Inserting Data into an Existing Table
PHP MSSQL - Making Columns to Take NULL
PHP MSSQL - Inserting Data with NULL Values
PHP MSSQL - Inserting Multiple Rows with a Subquery
PHP MSSQL - mssql_rows_affected() - Number of Affected Rows
PHP MSSQL - Returning Result Set Objects
PHP MSSQL - mssql_fetch_array() - Looping through Returning Rows
PHP MSSQL - Updating Existing Rows in a Table
PHP MSSQL - Deleting Existing Rows in a Table
PHP MSSQL - Including Text Values in SQL Statements
PHP MSSQL - Including Date and Time Values in SQL Statements
PHP MSSQL - Computing Date and Time Differences
PHP MSSQL - Searching Records by Keywords
Please note that all answers and tutorials are based on SQL Server 2005 Express Edition and PHP 5 on Windows XP. To follow tutorial exercises in this collection, you need to use test tables created from previous tutorial collections.
⇒ PHP MSSQL - Creating a New Table
✍: Guest
2024-03-07, 1254🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...