General MySQL Oracle SQL Server

<< < … 14 15 16 17 18 19 20 >   ∑:469  Sort:Date

"ALTER TRIGGER" - Modifying Existing Triggers in SQL Server
How To Modify Existing Triggers using "ALTER TRIGGER" in SQL Server? If you want to make changes to an existing trigger, you could use the "ALTER TRIGGER" statements to refine the trigger again. The tutorial exercise below shows you how to modify the trigger defined in a previous tutorial: USE FyiCe... 2016-10-24, 1242🔥, 0💬

Turning on the MSSQL API Module
How to Turn on the MSSQL API Module? If you want to access SQL Server database with PHP scripts, the first thing you need to do is to turn on the MSSQL API Module as shown in this tutorial: 1. Prepare a single line script to test the MSSQL API Module: &lt;?php mssql_connect('LOCALHOST','sa' ,'FYI... 2024-04-14, 1241🔥, 0💬

Commonly Used MSSQL Functions in PHP
What Are Commonly Used MSSQL Functions in PHP? If you look at the PHP 5 manual, you will see a group of functions listed under the Microsoft SQL Server Functions section. The commonly used functions are: mssql_connect � Open MS SQL server connection mssql_close � Close MS SQL Server connection mssql... 2024-04-07, 1239🔥, 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, 1239🔥, 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, 1238🔥, 0💬

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; ... 2024-03-07, 1236🔥, 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, 1236🔥, 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, 1236🔥, 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, 1236🔥, 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, 1235🔥, 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, 1234🔥, 0💬

Defining Excel Files as the DTS Data Destination
How To Define Excel Files as the DTS Data Destination? Microsoft Excel is a nice tool to view and manage data in rows and columns. If you have a small database table, you may want to export its data to an Excel file so that you can make changes easily. This tutorial is a continuation of the previous... 2024-01-31, 1234🔥, 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, 1234🔥, 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, 1234🔥, 0💬

Missing ntwdblib.dll for MSSQL connection
What Happens If ntwdblib.dll Is Missing on Your Machine? In order to install the proper version of ntwdblib.dll on your machine, you need to find out how many copies of ntwdblib.dll do you have on your machine and what are the version numbers on those copies. 1. Go to Start &gt; Search &gt; ... 2024-04-14, 1232🔥, 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, 1232🔥, 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, 1232🔥, 0💬

Requirements for Connecting PHP to MS SQL Server
What Do You Need to Connect PHP to SQL Server? If you want to access MS SQL Server in your PHP script, you need to make sure that: 1. MSSQL API module (extension) is installed and turned on in your PHP engine. If you installed the Windows binary version of PHP 5.2.3, MSSQL API module is included but... 2024-04-29, 1231🔥, 0💬

mssql_close() - Disconnecting from a SQL Server
How To Disconnect from a SQL Server using mssql_close()? When you call mssql_connect(), it will return an object representing the connection to the SQL Server. This connection object will be used by subsequent MSSQL function calls. When you are done with this connection, you should close it to free ... 2024-04-07, 1231🔥, 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, 1230🔥, 0💬

MS SQL Server DBA Checklist - General DBA Best Practices
-- Join (or start) a local SQL Server users group -- Attend at least one professional conference each year. -- Attend at least one training session each year. -- Read at least four books on SQL Server each year. -- Read the free e-book, How to Become an Exceptional DBA -- Learn everything you can ab... 2022-01-24, 1227🔥, 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, 1226🔥, 0💬

Finding ntwdblib.dll Version 2000.80.194.0
Where to Find ntwdblib.dll Version 2000.80.194.0? You know that the copy of ntwdblib.dll version 2000.2.8.0 included in Windows binary version of PHP 5.2.3 does not work with MS SQL Server 2005. You need to get a new version of ntwdblib.dll. One way to get a free copy of ntwdblib.dll is to download ... 2024-04-14, 1225🔥, 0💬

mssql_field_name() - Retrieve Field Names
How To List All Field Names in the Result Set using mssql_field_name()? The result set object returned by a SELECT statement also contains column (field) names, lengths and types. You can use mssql_field_name(), mssql_field_length() and mssql_field_type() to get those information. The tutorial exerc... 2024-03-23, 1225🔥, 0💬

<< < … 14 15 16 17 18 19 20 >   ∑:469  Sort:Date

General MySQL Oracle SQL Server