General MySQL Oracle SQL Server

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

Using Group Functions in the ORDER BY Clause in SQL Server
Can Group Functions Be Used in the ORDER BY Clause in SQL Server? 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 the maximum "counts" in each group, determined by a unique combination of tag and ye... 2016-10-25, 2565🔥, 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, 2563🔥, 0💬

Creating Local Temporary Stored Procedures in SQL Server
How To Create a Local Temporary Stored Procedure in SQL Server Transact-SQL? A local temporary stored procedure is a special stored procedure that: Is created like a normal (permanent) stored procedure with the name prefixed with a number sign (#). Are only valid in the same client session where it ... 2016-12-28, 2558🔥, 0💬

Creating an Index on a View in SQL Server
How To Create an Index on a View in SQL Server? If you need to search and sort data in a view with a large number of row, you may want to create an index on the view to speed up your search process. The tutorial exercise below shows you how to create a unique clustered index on a view. DROP VIEW fyi... 2016-11-03, 2558🔥, 0💬

NULL Values Involved in Datetime Operations in SQL Server
What Happens If NULL Values Are Involved in Datetime Operations in SQL Server Transact-SQL? If NULL values are involved in datetime operations, the result will be datetime NULL values. The following tutorial script shows you some good examples: USE FyiCenterData; GO SELECT GETDATE()+NULL; GO -------... 2017-02-05, 2553🔥, 0💬

Checking Your PHP Installation
How To Check Your PHP Installation? PHP provides two execution interfaces: Command Line Interface (CLI) and Common Gateway Interface (CGI). If PHP is installed in the \php directory on your system, you can try this to check your installation: Run "\php\php -v" command to check the Command Line Inter... 2024-04-29, 2540🔥, 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, 2539🔥, 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, 2537🔥, 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, 2537🔥, 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, 2535🔥, 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, 2533🔥, 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, 2532🔥, 0💬

Assigning NULL Values to Variables or Columns in SQL Server
How To Assign NULL Values to Variables or Columns in SQL Server Transact-SQL? The rule for assigning NULL values to variables or table columns is simple: Use keyword "NULL" directly as normal values. "NULL" can be used in SET statements to assign NULL values to variables. "NULL" can be used in SET c... 2017-02-05, 2532🔥, 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, 2532🔥, 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, 2529🔥, 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, 2529🔥, 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, 2526🔥, 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, 2520🔥, 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, 2518🔥, 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, 2516🔥, 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, 2515🔥, 1💬

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, 2515🔥, 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, 2508🔥, 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, 2507🔥, 0💬

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

General MySQL Oracle SQL Server