General MySQL Oracle SQL Server

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

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, 2154🔥, 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, 2153🔥, 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, 2151🔥, 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, 2151🔥, 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, 2150🔥, 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, 2143🔥, 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, 2142🔥, 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, 2140🔥, 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, 2139🔥, 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, 2138🔥, 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, 2137🔥, 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, 2137🔥, 0💬

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, 2132🔥, 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, 2132🔥, 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, 2131🔥, 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, 2130🔥, 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, 2127🔥, 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, 2127🔥, 0💬

PHP ODBC - Inserting Multiple Rows with a Subquery
PHP ODBC - 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 = odbc_connect('FYI_SQL_SERVER', 'sa','FYIcenter');$sql = "... 2024-05-29, 2124🔥, 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, 2124🔥, 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, 2123🔥, 0💬

PHP ODBC - Returning Result Set Objects
PHP ODBC - What Is a Result Set Object Returned by odbc_exec()? A result set object is a logical representation of data rows returned by odbc_exec() 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 resul... 2024-05-29, 2119🔥, 0💬

"AS" - Naming Query Output Columns in SQL Server
How To Name Query Output Columns in SQL Server? Each column in the query output has a default name. If you don't like the default name, you can specify a new name for any column in the query output by using the AS clause. The following statement shows you a good example: SELECT tag AS Category, YEAR... 2016-10-29, 2116🔥, 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, 2112🔥, 0💬

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

General MySQL Oracle SQL Server