General MySQL Oracle SQL Server

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

odbc_result() - Retrieve Field Values
How To Retrieve Field Values using odbc_result()? After calling odbc_fetch_row(), the field values of the fetched row are available in the result set object. You can use odbc_result() to retrieve the value of any given field with two syntax formats: $value = odbc_result($field_name); #- Retrieving v... 2024-07-11, 2818🔥, 0💬

What Are Triggers in SQL Server
What Are Triggers in SQL Server? A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. A trigger is really an event handler. SQL Server allows users to create triggers (event handlers) for 3 types of events: DML Event - Occurs when a... 2016-10-25, 2813🔥, 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, 2811🔥, 0💬

DROP VIEW - Deleting Existing Views in SQL Server
How To Drop Existing Views from a Database in SQL Server? If you don't need a specific view any more, you can use the DROP VIEW statement to delete it from the database. The following tutorial exercise shows you how to delete the view, fyi_links_view: USE FyiCenterData; GO SELECT * FROM sys.views; G... 2016-11-05, 2809🔥, 0💬

Simplest Way To Create New Databases in SQL Server
What is the simplest way to create a new database in SQL Server? The simplest way to create a new database is to use the "CREATE DATABASE" statement with this syntax: CREATE DATABASE database_name For example, run this statement: CREATE DATABASE FyiCenterData GO A new database called "FyiCenterData"... 2016-11-24, 2805🔥, 0💬

PHP ODBC - Inserting Data into an Existing Table
PHP ODBC - How To Insert Data into an Existing Table? If you want to insert a row of data into an existing table, you can use the INSERT INTO statement as shown in the following sample script: &lt;?php $con = odbc_connect('FYI_SQL_SERVER', 'sa','FYIcenter');$sql = "INSERT INTO fyi_links (id, url... 2024-06-03, 2795🔥, 0💬

PHP MSSQL - Inserting Data into an Existing Table
PHP MSSQL - How To Insert Data into an Existing Table? If you want to insert a row of data into an existing table, you can use the INSERT INTO statement as shown in the following sample script: &lt;?php $con = mssql_connect('LOCALHOST','sa' ,'FYIcenter');mssql_select_db('FyiCenterData ',$con); $... 2024-03-07, 2793🔥, 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, 2791🔥, 0💬

mssql_get_last_message() - Retrieving Error Messages
How To Retrieve Error Messages using mssql_get_last_message()? When you call mssql_query() to execute a SQL statement, and the execution failed on the SQL Server, you can use mssql_get_last_message() function to retrieve the error messages. The tutorial script below shows you a good example: &lt... 2024-04-07, 2771🔥, 0💬

Creating a Simple Table to Test Triggers in SQL Server
How To Create a Simple Table to Test Triggers in SQL Server? If you want to follow other tutorial examples included in this collection, you need to run this SQL script to create a simple table called fyi_users: USE FyiCenterData; GO DROP TABLE fyi_users; GO CREATE TABLE fyi_users ( id INTEGER IDENTI... 2016-10-25, 2770🔥, 0💬

odbc_connect() - Connecting to a SQL Server through an ODBC DSN
How To Connect to a SQL Server using odbc_connect()? If you have an ODBC DSN (Data Source Name) created linking to a SQL Server, you are ready to connect to the SQL Server through the DSN with ODBC functions. There is no changes needed in the php.ini configuration file. The tutorial script below sho... 2024-07-11, 2764🔥, 0💬

Filtering Out Duplications in the Returning Rows in SQL Server
How To Filter Out Duplications in the Returning Rows in SQL Server? If there are duplications in the returning rows, and you want to remove the duplications, you can use the keyword DISTINCT in the SELECT clause. The DISTINCT applies to the combination of all data fields specified in the SELECT clau... 2016-10-26, 2764🔥, 0💬

odbc_data_source() - Listing All DSN Entries
How To List All DSN Entries on Your Local Machine using odbc_data_source()? If you are interested to know what DSN entries are available on your local machine, you can use odbc_data_source($con, SQL_FETCH_FIRST) and odbc_data_source($con, SQL_FETCH_NEXT) in a loop to list all DSN entries defined on ... 2024-07-11, 2758🔥, 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, 2758🔥, 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, 2754🔥, 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, 2754🔥, 0💬

Adding More Test Data for Query Statements in SQL Server
How To Add More Data to the Testing Table in SQL Server? If you want to continue with other tutorial exercises in this FAQ collection, you need to add more data to the testing table. Follow the script below to add a new column and more rows: ALTER TABLE fyi_links ADD tag VARCHAR(8) GO UPDATE fyi_lin... 2016-10-26, 2749🔥, 0💬

Testing ODBC DSN Connection Settings
How To Test ODBC DSN Connection Settings? Assuming you have followed other FYIcenter.com tutorials and created an ODBC DSN called "FYI_SQL_SERVER", and planning to use it your PHP scripts, you should test this ODBC connection first as shown in this tutorial: 1. Go to Control Panel &gt; Administr... 2024-07-11, 2747🔥, 0💬

Security Model Used in SQL Server 2005 in SQL Server
What Is the Security Model Used in SQL Server 2005 in SQL Server? SQL Server 2005 uses a very standard security model involves 3 concepts: Securables - Entities representing resources that need to be secured. For example, a database table is a securable. Principals - Entities representing users that... 2016-10-20, 2739🔥, 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, 2736🔥, 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, 2735🔥, 0💬

PHP ODBC - Computing Date and Time Differences
PHP ODBC - 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 present... 2024-05-05, 2730🔥, 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, 2723🔥, 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, 2723🔥, 0💬

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

General MySQL Oracle SQL Server