General MySQL Oracle SQL Server

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

Sorting Query Output by Multiple Columns in SQL Server
Can the Query Output Be Sorted by Multiple Columns in SQL Server? You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns rows sorted by "tag" and "counts" values: SELECT tag, counts, url, created FROM fyi_links ORDER BY tag, counts GO ta... 2016-10-26, 2883🔥, 0💬

Using Group Functions in the SELECT Clause in SQL Server
How To Use Group Functions in the SELECT Clause in SQL Server? If group functions are used in the SELECT clause, all rows that meet the criteria defined in the WHERE clause will be treated as a single group. The group functions will be apply all rows in that group as a whole. The final output of the... 2016-10-25, 2883🔥, 0💬

HAVING - Apply Filtering Criteria at Group Level in SQL Server
How To Apply Filtering Criteria at Group Level with The HAVING Clause in SQL Server? Let's say you have divided the query output into multiple groups with the GROUP BY clause. Now you are only interested in some of the groups, not all the groups. If you want to filter out some groups from the query,... 2016-10-25, 2883🔥, 0💬

PHP ODBC - Including Text Values in SQL Statements
PHP ODBC - How To Include Text Values in SQL Statements? Text values in SQL statements should be quoted with single quotes ('). If the text value contains a single quote ('), it should be protected by replacing it with two single quotes (''). In SQL language syntax, two single quotes represents one ... 2024-05-05, 2879🔥, 0💬

Joining Two Tables in a Single Query in SQL Server
How To Join Two Tables in a Single Query in SQL Server? Two tables can be joined together in a query in 4 ways: Inner Join: Returns only rows from both tables that satisfy the join condition. Left Outer Join: Returns rows from both tables that satisfy the join condition, and the rest of rows from th... 2016-10-30, 2876🔥, 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, 2876🔥, 0💬

Writing Inner Joins with the WHERE Clause in SQL Server
How To Write an Inner Join with the WHERE Clause in SQL Server? If you don't want to use the INNER JOIN ... ON clause to write an inner join, you can put the join condition in the WHERE clause as shown in the following query example: SELECT l.id, l.url, r.comment FROM fyi_links l, fyi_rates r WHERE ... 2016-10-29, 2870🔥, 0💬

PHP MSSQL - Searching Records by Keywords
PHP MSSQL - How To Perform Key Word Search in Tables? The simplest way to perform key word search is to use the SELECT statement with a LIKE operator in the WHERE clause. The LIKE operator allows you to match a text field with a keyword pattern specified as '%keyword%', where (%) represents any numb... 2024-02-09, 2866🔥, 0💬

Creating and Managing Schemas in SQL Server
Where to find answers to frequently asked questions on Creating and Managing Schemas in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Creating and Managing Schemas in SQL Server. Clear answers are provided with tutorial exercises on ... 2016-10-22, 2865🔥, 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, 2864🔥, 0💬

Deleting an Existing Row with DELETE Statements in SQL Server
How To Delete an Existing Row with DELETE Statements in SQL Server? If you want to delete an existing row from a table, you can use the DELETE statement with a WHERE clause to identify that row. Here is good sample of DELETE statements: -- insert a row for this test INSERT INTO fyi_links (url, id) V... 2016-10-30, 2863🔥, 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, 2862🔥, 0💬

"DELETED" - Old Record of an DML Event Instance in SQL Server
How To Access the Deleted Record of an Event in SQL Server? When a DML event occurs, SQL Server will prepare a temporary table called "DELETED", which contains the old record of the affected row, which is: A copy of the deleted row for a DELETE statement. A copy of the row to be updated for an UPDAT... 2016-10-24, 2862🔥, 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, 2860🔥, 0💬

SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution
A collection of 18 FAQs on connecting to MS SQL Server with PHP scripts. Clear explanations and tutorial exercises are provided on SQL Server connection; providing port number; selecting database; running SQL statements; checking execution errors; looping through query result; looping through result... 2024-04-29, 2858🔥, 0💬

Returning Result from Query with ODBC Connection
How To Receive Returning Result from a Query? When you execute a SQL SELECT statement with the odbc_exec() function, you can capture the returning result with a result set object with the following syntax: $result_set = odbc_exec($sql_statement); #- The returning value could be a Boolean value FALSE... 2024-07-17, 2856🔥, 1💬

LIKE - Matching a Pattern in a Character String in SQL Server
What To Perform Pattern Match with the LIKE Operator in SQL Server Transact-SQL? Pattern match is a very important operation for search records base on character string columns. SQL Server 2005 offers the LIKE operator to perform pattern match operations in two formats: target_string LIKE pattern --... 2017-01-21, 2852🔥, 0💬

Inserting Data into a View in SQL Server
Can You Insert Data into a View in SQL Server? Can you insert data into a view? The answer is no. But if the question is "Can you insert data into the underlying table through view?" The answer is then yes. SQL Server will allow you to insert data into the underlying table through a view with a cond... 2016-11-04, 2851🔥, 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, 2844🔥, 0💬

"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, 2843🔥, 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, 2836🔥, 0💬

Transferring Tables from One Schema to Another in SQL Server
How To Transfer an Existing Table from One Schema to Another Schema in SQL Server? If you want to move an existing table from one schema to another schema, you can use the "ALTER SCHEMA ... TRANSFER ..." statement as shown in the tutorial exercise below: -- Login with "sa" USE FyiCenterData; GO -- C... 2016-10-22, 2836🔥, 0💬

"TOP" - Return the Top 5 Rows from a SELECT Query in SQL Server
How To Return the Top 5 Rows from a SELECT Query in SQL Server? If you want the query to return only the first 5 rows, you can use the "TOP 5" clause. The TOP clause takes one parameter to indicate how many top rows to return. The following statements returns the first 5 rows and 3 rows from the fyi... 2016-10-29, 2834🔥, 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, 2828🔥, 0💬

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

General MySQL Oracle SQL Server