General MySQL Oracle SQL Server

<< < … 43 44 45 46 47 48 49 50 51 52 53 … > >>   ∑:1351  Sort:Date

User Account and Attributes in Oracle
What Is a User Account in Oracle? A user account is identified by a user name and defines user's attributes, including the following: Password for database authentication Privileges and roles Default tablespace for database objects Default temporary tablespace for query processing work space   ⇒ Use... 2019-07-30, 2212🔥, 0💬

Including Comments in SQL Statements in MySQL
How To Include Comments in SQL Statements in MySQL? If you want to include comments in a SQL statement, you can first enter "--", then enter your comment until the end of the line. The tutorial exercise below shows you some good examples: SELECT 'Hello world!' FROM DUAL; -- My first SQL statement! I... 2018-04-12, 2212🔥, 0💬

What Are Group Functions in MySQL
What Are Group Functions in MySQL? Group functions are functions applied to a group of rows. Examples of group functions are: COUNT(*) - Returns the number of rows in the group. MIN(exp) - Returns the minimum value of the expression evaluated on each row of the group. MAX(exp) - Returns the maximum ... 2018-01-06, 2211🔥, 0💬

Basic Features of a Trigger in SQL Server
What Are the Basic Features of a Trigger in SQL Server? Since a SQL Server trigger is a really an event handler, it has the following basic features similar to event handlers in other programming languages: Event Type - It must be declared to handle a specific event, like a DELETE event. Object Scop... 2016-10-25, 2210🔥, 0💬

Assign Data from a Deleted Row to Variables in Oracle
How To Assign Data of the Deleted Row to Variables in Oracle? If a DELETE statement is deleting a single row, you can assign column values of the deleted row to variables by using the RETURNING clause, which an extension of DELETE statements for PL/SQL. The tutorial script shows you how to do this: ... 2018-09-13, 2209🔥, 0💬

Expressions with NULL Values in MySQL
What Happens If NULL Values Are Involved in Expressions in MySQL? If NULL values are used in expressions, the resulting values will be NULL values. In other words: Arithmetic expressions with NULL values result NULL values. Comparison expressions with NULL values result NULL values. Logical expressi... 2018-03-28, 2209🔥, 0💬

Rename an Existing User Account in MySQL
How To Rename an Existing User Account Name in MySQL? If you want to change the name of an existing user account, you can use the "RENAME USER oldName TO newName" command. The tutorial exercise below shows you how to do this: &gt;cd \mysql\bin &gt;mysql -u root -pretneciyf mysql mysql&gt... 2017-12-13, 2209🔥, 0💬

ntwdblib.dll - SQL Server Client Library DLL
What Is Wrong with SQL Server Client Library DLL, ntwdblib.dll? The second requirement to access SQL Server with PHP scripts is the SQL Server Client Library DLL, ntwdblib.dll. The good news is that the Windows binary version of PHP 5.2.3 has ntwdblib.dll included in the PHP home directory. But the ... 2024-04-14, 2208🔥, 0💬

PHP ODBC - Deleting Existing Rows in a Table
PHP ODBC - How To Delete Existing Rows in a Table? If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row. The following sample script deletes one row: &lt;?php $con = odbc_connect('FYI_SQL_SERVER', 'sa','FYIcenter');$sql = "DELETE FROM... 2024-05-05, 2207🔥, 0💬

Update Values on Multiple Rows in Oracle
How To Update Values on Multiple Rows in Oracle? If the WHERE clause in an UPDATE matches multiple rows, the SET clause will be applied to all matched rows. This rule allows you to update values on multiple rows in a single UPDATE statement. Here is a good example: UPDATE fyi_links SET counts = 9, n... 2020-01-21, 2207🔥, 0💬

Categories of Functions Based on Return Modes in SQL Server
How Many Categories of Functions based Their Return Modes in SQL Server Transact-SQL? SQL Server supports 2 categories of user defined functions based on their return modes: 1. Scalar-valued Functions - A function that returns a single value. Scalar-valued functions can be used in scalar expressions... 2016-12-18, 2207🔥, 0💬

Define Variables before Procedures and Functions in Oracle
What Is the Order of Defining Local Variables and Sub Procedures/Functions in Oracle? In the declaration part, you must define all local variables before defining any sub procedures or sub functions. See the following sample script: SQL&gt; CREATE OR REPLACE PROCEDURE WELCOME AS 2 SITE CHAR(80) ... 2018-03-18, 2206🔥, 0💬

What Are Views in SQL Server
What Are Views in SQL Server? A view is a database object that represents the data in one or more tables in the same structure as a separate table. Here are some basic rules about views: Tables store real data. Views do not store real data. Views must have underlying tables to provide data. Each vie... 2016-11-08, 2205🔥, 0💬

Types of Execution Flow Control Statements in Oracle
What Are the Execution Control Statements in Oracle? PL/SQL supports three groups of execution control statements: IF Statements - Conditionally executes a block of statements. CASE Statements - Selectively executes a block of statements. LOOP Statements - Repeatedly executes a block of statements. ... 2018-11-17, 2202🔥, 0💬

Providing Default Values to Procedure Parameters in SQL Server
How To Provide Default Values to Stored Procedure Parameters in SQL Server Transact-SQL? If you add a parameter when creating a stored procedure, you can provide a default value so that the execution statement is not required to pass input value to this parameter. To provide a default value to a par... 2016-12-28, 2201🔥, 0💬

Getting "Connection failed" Error on ODBC DSN Creation
Why Am I Getting Errors When Creating a New ODBC DSN? Continue from the previous tutorial. After clicking Next on the SQL login information screen, ODBC manager will try to connect to the SQL Server with the login information you provided. After a period of waiting time, you may get error message bo... 2024-08-06, 2200🔥, 0💬

Providing Column Names in INSERT Statements in SQL Server
How to provide column names in INSERT Statements in SQL Server? If you don't want to specify values for columns that have default values, or you want to specify values to columns in an order different than how they are defined, you can provide a column list in the INSERT statement. If a column is om... 2016-11-02, 2200🔥, 0💬

Retrieve Field Values from RECORD Variables in Oracle
How To Retrieve Values from Data Fields in RECORD Variables in Oracle? If a variable is a RECORD variable with data fields assigned values, you can retrieve those values out of its data fields by using fields names prefixed with variable name as "variable.field_name". Here is a sample script showing... 2018-09-01, 2199🔥, 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, 2199🔥, 0💬

What Are User Defined Functions in SQL Server
What Are User Defined Functions in SQL Server Transact-SQL? A user defined function is a collection of Transact-SQL statements that stored in the SQL Server. A user defined function will return data when executed. A user defined function works in the same way as a system function. It can be used as ... 2016-12-28, 2199🔥, 0💬

Requirements for Connecting PHP to MS SQL Server
What Do You Need to Connect PHP to SQL Server? If you want to access MS SQL Server in your PHP script, you need to make sure that: 1. MSSQL API module (extension) is installed and turned on in your PHP engine. If you installed the Windows binary version of PHP 5.2.3, MSSQL API module is included but... 2024-04-29, 2198🔥, 0💬

Query Output Sorted by Multiple Columns in Oracle
Can the Query Output Be Sorted by Multiple Columns in Oracle? You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns employees' salaries sorted by department and salary value: SQL&gt; SELECT department_id, first_name, last_name, sala... 2019-12-19, 2197🔥, 0💬

Requirements on SQL Server Network Connections
What Are the Requirements on SQL Server Network Connections? By default, SQL Server 2005 Express Edition is installed only one connection protocol enabled: Shared Memory - SQL Server connection protocol for applications that are running on the same machine where the SQL Server is running. For exampl... 2024-08-06, 2195🔥, 0💬

Connecting MS Access to SQL Servers through ODBC
How To Connect MS Access to SQL Servers through ODBC? Once you got a DSN defined in the ODBC manager that connects to your SQL Server, you can connect a normal MS Access document to the Oracle server, and link an Access table to a SQL Server table. The tutorial below gives you a good example: Start ... 2024-03-17, 2195🔥, 0💬

<< < … 43 44 45 46 47 48 49 50 51 52 53 … > >>   ∑:1351  Sort:Date

General MySQL Oracle SQL Server