General MySQL Oracle SQL Server

<< < … 24 25 26 27 28 29 30 31 32 33 34 … > >>   ∑:1351  Sort:Date

"mysqld" Command Line Options in MySQL
What Are the "mysqld" Command Line Options in MySQL? "mysqld" offers a big list of command line options. Here are some commonly used options: "--help" - Displays a short help message on how to use "mysqld". "--verbose --help" - Displays a long help messages on how to use "mysqld". "--console" - Spec... 2017-12-04, 2508🔥, 0💬

What Are Comparison Operations in SQL Server
What Are Comparison Operations in SQL Server Transact-SQL? Comparison operations return Boolean values by comparing the relative positions of two operands. SQL server supports the following comparison operations: = (Equal To): Returns Boolean true, if two operands are equal in value. &gt; (Great... 2017-01-29, 2508🔥, 0💬

Casting Numeric Values to DATETIME in SQL Server Transact-SQL
Can I cast numeric values to DATETIME values in SQL Server Transact-SQL? Yes, you can cast numeric values to DATATIME values in Transact-SQL. The implicit casting rules are for numeric values to DATETIME values are: Numeric values are casted linearly to DATETIME values. Decimal 0 represents 1900-01-... 2017-04-15, 2507🔥, 0💬

"CREATE USER" Statements - Creating a User in SQL Server
How to create a user to access a database using "CREATE USER" statements in SQL Server? This is the second tutorial of a quick lesson on creating login and configure users for databases with Transact-SQL statements. Granting a user access to a database involves three steps. First, you create a login... 2016-11-27, 2506🔥, 0💬

Shutting Down MySQL Server in MySQL
How To Shutdown MySQL Server in MySQL? If you want to shutdown your MySQL server, you can run the "mysqladmin" program in a command window as shown in the following tutorial: &gt;cd \mysql\bin &gt;mysqladmin shutdown   ⇒ Administrator Tools for Managing MySQL Server ⇐ Creating a Test Table ... 2018-06-06, 2505🔥, 0💬

Show Installed Oracle ODBC Drivers in Oracle
How To Find Out What Oracle ODBC Drivers Are Installed in Oracle? To find out what Oracle ODBC drivers are installed on your Windows system, you can use the ODBC manager to look at them: Go to Control Panel. Go to Administrative Tools. Run Data Sources (ODBC). Go to System DSN tab. Click the Add but... 2016-10-15, 2505🔥, 0💬

Convert Numbers to Character Strings in Oracle
How To Convert Numbers to Character Strings in Oracle? You can convert numeric values to characters by using the TO_CHAR() function as shown in the following examples: SELECT TO_CHAR(4123.4570) FROM DUAL 123.457 SELECT TO_CHAR(4123.457, '$9,999,999.99') FROM DUAL $4,123.46 SELECT TO_CHAR(-4123.457, ... 2020-03-25, 2504🔥, 0💬

Define Anonymous Procedures without Variables in Oracle
How To Define an Anonymous Procedure without Variables in Oracle? Anonymous procedure is a procedure without any name. If you don't have any variables to declare, you can define an anonymous procedure by using the BEGIN keyword directly in SQL*Plus as shown in the following tutorial script: SQL&... 2018-01-27, 2504🔥, 0💬

Pass a Cursor Variable to a Procedure in Oracle
How To Pass a Cursor Variable to a Procedure in Oracle? A cursor variable can be passed into a procedure like a normal variable. The sample script below gives you a good example: CREATE OR REPLACE PROCEDURE FYI_CENTER AS sys_cur SYS_REFCURSOR; PROCEDURE emp_print(cur SYS_REFCURSOR) AS emp_rec employ... 2018-07-18, 2502🔥, 0💬

Select Some Columns from a Table in Oracle
How To Select Some Columns from a Table in Oracle? If you want explicitly tell the query to some columns, you can specify the column names in SELECT clause. The following select statement returns only two columns from the table "departments": SQL&gt; SELECT location_id, department_name FROM DEPA... 2019-12-19, 2501🔥, 0💬

Name Conflicts between Variables and Columns in Oracle
How To Resolve Name Conflicts between Variables and Columns in Oracle? The best way to resolve name conflicts is to avoid using column names for variables.   ⇒ Assign Query Results to Variables in Oracle ⇐ Variable Names Collide with Column Names in Oracle ⇑ Working with Database Objects in Oracle ... 2018-09-24, 2501🔥, 0💬

Logical Operations in PL/SQL in Oracle
What Are the Logical Operations in Oracle? PL/SQL supports 3 logical operations as shown in the following sample script: PROCEDURE proc_comparison AS x BOOLEAN := TRUE; y BOOLEAN := FALSE; res BOOLEAN; BEGIN res = x AND y; res = x OR y; res = NOT x; -- more statements END;   ⇒ Categories of Data Typ... 2018-08-06, 2501🔥, 0💬

Transaction Committed when START TRANSACTION Executed in MySQL
What Happens to the Current Transaction If a START TRANSACTION Is Executed in MySQL? If you are in a middle of a current transaction, and a START TRANSACTION command is executed, the current transaction will be committed and ended. All the database changes made in the current transaction will become... 2016-10-17, 2501🔥, 0💬

Install Oracle SQL Developer in Oracle
How To Install Oracle SQL Developer in Oracle? Once you have sqldeveloper-v1.0.0.zip downloaded, extract the zip file into the root directory: \. When the extraction is done, the installation is completed. Your copy of Oracle SQL Developer is installed in directory: \sqldeveloper, and ready to run. ... 2019-02-05, 2500🔥, 0💬

Install Oracle SQL Developer in Oracle
How To Install Oracle SQL Developer in Oracle? Once you have sqldeveloper-v1.0.0.zip downloaded, extract the zip file into the root directory: \. When the extraction is done, the installation is completed. Your copy of Oracle SQL Developer is installed in directory: \sqldeveloper, and ready to run. ... 2019-02-05, 2500🔥, 0💬

Define Default Values for Formal Parameters in Oracle
How To Define Default Values for Formal Parameters in Oracle? If you have an IN parameter, you can make it as an optional parameter for the calling statement by defining the formal parameter with the DEFAULT clause. This gives you the freedom of not providing the actual parameter when calling this p... 2018-10-19, 2498🔥, 0💬

Location of Database Files in SQL Server
Where is my database stored on the hard disk in SQL Server? If a database is created with simple CREATE DATABASE statement, the server will create two database files on the hard disk to store data and configuration information about that data bases: database_name.mdf - SQL Server Database Primary Da... 2016-11-24, 2498🔥, 0💬

Assigning New Column Names in a View in SQL Server
How To Assign New Column Names in a View in SQL Server? By default, column names in a view are provided by the underlying SELECT statement. But sometimes, the underlying SELECT statement can not provide names for output columns that specified as expressions with functions and operations. In this cas... 2016-11-03, 2498🔥, 0💬

DEFAULT - Using Column Default Values in INSERT Statements in SQL Server
How To Use Column Default Values in INSERT Statements in SQL Server? If a column is defined with a default value in a table, you can use the key word DEFAULT in the INSERT statement to take the default value for that column. The following tutorial exercise gives a good example: INSERT INTO fyi_links... 2016-11-03, 2498🔥, 0💬

Unlock the Sample User Account in Oracle
How To Unlock the Sample User Account in Oracle? Your 10g XE server comes with a sample database user account called HR. But this account is locked. You must unlock it before you can use it: Log into the server home page as SYSTEM. Click the Administration icon, and then click Database Users. Click ... 2020-09-30, 2497🔥, 0💬

Entering Binary Numbers in MySQL
How To Enter Binary Numbers in SQL Statements in MySQL? If you want to enter character strings or numeric values as binary numbers, you can quote binary numbers with single quotes and a prefix of (B), or just prefix binary numbers with (0b). Binary numbers will be automatically converted into charac... 2018-03-31, 2497🔥, 0💬

VERSION() - Version Number of MySQL Server
How to obtain the version number of the MySQL server using the VERSION() function? VERSION() is a MySQL built-in function that returns the version number of the MySQL server. For example: SELECT VERSION(); -- +-----------+ -- | VERSION() | -- +-----------+ -- | 8.0.17 | -- +-----------+ SELECT @@ver... 2025-01-07, 2496🔥, 0💬

How Oracle Handles Dead Locks in Oracle
How Oracle Handles Dead Locks in Oracle? Oracle server automatically detects dead locks. When a dead lock is detected, Oracle server will select a victim transaction, and fail its statement that is blocked in the dead lock to break the dead lock. The tutorial exercise below shows you an example of s... 2019-08-08, 2496🔥, 0💬

Adding Address Records into AdventureWorksLT in SQL Server
How to add an address record into AdventureWorksLT in SQL Server? To find out if we can add data into AdventureWorksLT or not, you can try to add an address record into the "SalesLT.Address" in AdventureWorksLT: USE AdventureWorksLT GO INSERT SalesLT.Address (AddressLine1, City, StateProvince, Count... 2016-12-02, 2496🔥, 0💬

<< < … 24 25 26 27 28 29 30 31 32 33 34 … > >>   ∑:1351  Sort:Date

General MySQL Oracle SQL Server