General MySQL Oracle SQL Server

<< < … 47 48 49 50 51 52 53 54 55 56 57 > >>   ∑:1354  Sort:Date

UNCOMPRESS() - Uncompressing Data
How to uncompress (restore) compressed data using the UNCOMPRESS() function? UNCOMPRESS(str) is a MySQL built-in function that uncompresses a given compressed byte string using the default LZ77 compression algorithm. For example: SELECT UNCOMPRESS(x'37000000789C738BF 44C4ECD2B492DD24BCECFD57123960 700... 2024-12-18, 2230🔥, 0💬

Using Subqueries with the IN Operators in SQL Server
How To Use Subqueries with the IN Operators in SQL Server? A subquery can be used with the IN operator as "expression IN (subquery)". The subquery should return a single column with one or more rows to form a list of values to be used by the IN operation. The following tutorial exercise shows you ho... 2016-10-29, 2230🔥, 0💬

Running MySQL Server on a Specific Port in MySQL
How To Run MySQL Server on a Different Port in MySQL? By default, MySQL will listen at port number 3306 for any client connections. But you can change this by starting the server with "--port=portNumber" option. The tutorial exercise shows you how to start the server to listen to a different port nu... 2017-11-29, 2229🔥, 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, 2228🔥, 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, 2224🔥, 0💬

PHP ODBC - odbc_num_rows() - Number of Affected Rows
PHP ODBC - How To Get the Number of Affected Rows? If you insert multiple rows with a single INSERT statement, you can use the odbc_num_rows() function to find out how many rows were inserted. odbc_num_rows($result_set) returns the number of affected rows based on the result set object returned by t... 2024-05-29, 2222🔥, 0💬

Configuring and Testing ODBC DSN Settings
How To Configure and Test ODBC DSN Settings? Continue from the previous tutorial. Click Next after you have finished changing the port number. The ODBC Data Source Administrator will try to connect to the SQL server through the specified port number and login information. If the connection is succes... 2024-07-25, 2221🔥, 0💬

PHP ODBC - Creating an Identity Column
PHP ODBC - 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 nu... 2024-04-29, 2220🔥, 0💬

odbc_columns() - Listing All Columns in a Table
How To List All Columns in a Table using odbc_columns()? If you want to get a list of all columns in a table, you can use the odbc_columns() function, which can actually be used to list all columns in all tables and views in the database. The syntax of odbc_columns() is: $result_set = odbc_columns($... 2024-06-03, 2219🔥, 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, 2216🔥, 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, 2214🔥, 0💬

Using Group Functions in the ORDER BY Clause in MySQL
Can Group Functions Be Used in the ORDER BY Clause in MySQL? If the query output is aggregated as groups, you can sort the groups by using group functions in the ORDER BY clause. The following statement returns how many links were created in each year in each tag. The group output is sorted by the c... 2017-12-31, 2213🔥, 0💬

NULL Values Involved in String Operations in SQL Server
What Happens If NULL Values Are Involved in String Operations in SQL Server Transact-SQL? If NULL values are involved in string operations, the result will be string NULL values. The following tutorial script shows you some good examples: SELECT 'FyiCenter'+NULL; GO ---------- NULL SELECT LEN(NULL);... 2017-02-05, 2211🔥, 0💬

Deleting Data from a View in SQL Server
Can You Delete Data from a View in SQL Server? Can you delete data in a view? The answer is no. But if the question is "Can you delete data from the underlying table through view?" The answer is then yes. SQL Server will allow you to delete data from the underlying table through a view. The tutorial... 2016-11-03, 2210🔥, 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, 2209🔥, 0💬

Using LIKE Conditions in MySQL
How To Use LIKE Conditions in MySQL? A LIKE condition is also called pattern patch. There are 3 main rules on using LIKE condition: '_' is used in the pattern to match any one character. '%' is used in the pattern to match any zero or more characters. ESCAPE clause is used to provide the escape char... 2018-03-24, 2208🔥, 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, 2204🔥, 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, 2202🔥, 0💬

Using User Defined Functions in Expressions in SQL Server
How To Use User Defined Functions in Expressions in SQL Server Transact-SQL? An user defined function must return a value, which can be used in any expression as long as the return value data type matches the expression. To execute a user defined function and use its return value in an expression, y... 2016-12-24, 2198🔥, 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, 2196🔥, 0💬

Installing DTS on Windows XP Systems
How To Install DTS (Data Transformation Services) on Windows XP Systems? SQL Server 2000 is not supported on Windows XP systems, but you can still install DTS (Data Transformation Services) as client component your XP system. This allows you to continue to use DTS with SQL Server 2005, if you don't ... 2024-01-31, 2194🔥, 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, 2193🔥, 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, 2191🔥, 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, 2191🔥, 0💬

<< < … 47 48 49 50 51 52 53 54 55 56 57 > >>   ∑:1354  Sort:Date

General MySQL Oracle SQL Server