General MySQL Oracle SQL Server

<< < … 26 27 28 29 30 31 32 33 34 35 36 … > >>   ∑:1360  Sort:Date

Loading Data Files with "mysqlimport" Command in MySQL
How To Load Data Files into Tables with "mysqlimport" in MySQL? If you want to load a data file directly into a table, you need to prepare the data file as one line per data row, and use tab character as the column delimiter. The data file name should match the target table name. The following is a ... 2018-04-28, 2782🔥, 0💬

Define Anonymous Procedures with Variables in Oracle
How To Define an Anonymous Procedure with Variables in Oracle? Anonymous procedure is a procedure without any name. If you have some variables to declare, you can define an anonymous procedure by using the DECLARE keyword in SQL*Plus as shown in the following tutorial script: SQL&gt; set servero... 2018-01-27, 2781🔥, 0💬

Create a New User Account in Oracle
How To Create a New User Account in Oracle? If you want to create a new user account, you can log in as SYSTEM and use the CREATE USER command as shown in the following example: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; CREATE USER DEV IDENTIFIED BY dev... 2019-07-21, 2779🔥, 0💬

NULL Values Involved in Boolean Operations in SQL Server
What Happens If NULL Values Are Involved in Boolean Operations in SQL Server Transact-SQL? If NULL values are involved in Boolean operations, the result will vary depending on the operator type. For AND operator, FALSE takes precedence over NULL. The result can be summarized in a table below: AND TR... 2017-02-03, 2779🔥, 0💬

Passing Values to User Defined Function Parameters in SQL Server
How To Provide Values to User Defined Function Parameters in SQL Server Transact-SQL? If a user defined function is created with parameters, you need pass values to those parameters when calling the function with one of two formats listed below: expression... function_name(value_1, value_2, ... valu... 2016-12-18, 2779🔥, 0💬

SGA Setting Is Too Low in Oracle
What Happens If You Set the SGA Too Low in Oracle? Let's you made a mistake and changed to SGA to 16MB from the SYSTEM admin home page. When you run the batch file StartDB.bat, it will return a message saying server stated. However, if you try to connect to your server home page: http://localhost:80... 2020-09-30, 2778🔥, 0💬

Lock and Unlock a User Account in Oracle
How To Lock and Unlock a User Account in Oracle? If you want to lock a user account for a short period of time, and unlock it later, you can use the ALTER USER ... ACCOUNT command. The following sample script shows how to use this command: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyic... 2019-06-29, 2778🔥, 0💬

Select Rows with WHERE Clause in MySQL
How To Select Some Rows from a Table in MySQL? If you don't want select all rows from a table, you can specify a WHERE clause to tell the query to return only the rows that meets the condition defined in the WHERE clause. The WHERE clause condition is a normal Boolean expression. If any data from ta... 2017-11-02, 2776🔥, 0💬

Tables Using MyISAM Storage Engine in MySQL
How To Create a New Table Using MyISAM Storage Engine in MySQL? MyISAM storage engine is based on the ISAM (Indexed Sequential Access Method) concept, which was first developed at IBM to store and retrieve data on secondary storage systems like tapes. MyISAM storage engine offers fast data storage a... 2017-09-12, 2775🔥, 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, 2775🔥, 0💬

What Is a SELECT Query Statement in SQL Server
What Is a SELECT Query Statement in SQL Server? The SELECT statement is also called the query statement. It is the most frequently used SQL statement in any database application. SELECT statements allows you to retrieve data from one or more tables or views, with different selection criteria, groupi... 2016-10-26, 2775🔥, 0💬

Empty Your Recycle Bin in Oracle
How To Empty Your Recycle Bin in Oracle? If your recycle bin is full, or you just want to clean your recycle bin to get rid of all the dropped tables, you can empty it by using the PURGE statement in two formats: PURGE RECYCLEBIN - Removes all dropped tables from your recycle bin. PURGE TABLE table_... 2019-05-10, 2774🔥, 0💬

Create a New Tablespace in Oracle
How To Create a New Tablespace in Oracle? If you want a new dataspace, you can use the CREATE TABLESPACE ... DATAFILE statement as shown in the following script: SQL&gt; CREATE TABLESPACE my_space 2 DATAFILE '/temp/my_space.dbf' SIZE 10M; Tablespace created. SQL&gt; SELECT TABLESPACE_NAME, S... 2019-04-13, 2774🔥, 0💬

Rename a Column in an Existing Table in Oracle
How To Rename a Column in an Existing Table in Oracle? Let's say you have an existing with an existing column, but you don't like the name of that column, can you rename that column name? The answer is yes. You can use the ALTER TABLE ... RENAME COLUMN statement to do this. See the following SQL scr... 2019-05-25, 2772🔥, 0💬

Add a New Column to an Existing Table in Oracle
How To Add a New Column to an Existing Table in Oracle? If you have an existing table with existing data rows, and want to add a new column to that table, you can use the ALTER TABLE ... ADD statement to do this. Here is an example script: SQL&gt; connect HR/fyicenter Connected. SQL&gt; CREA... 2019-05-25, 2772🔥, 0💬

Use "OUT" Parameters in Oracle
How To Use "OUT" Parameter Properly in Oracle? Here are the rules about OUT parameters: A formal OUT parameter acts like an un-initialized variable. It must be assigned with new values before the end of the procedure or function. An actual OUT parameter must be a variable. An actual OUT parameter wi... 2018-10-19, 2772🔥, 0💬

Using Column Default Values in MySQL
How To Specify Default Values in INSERT Statement in MySQL? 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: mysql&gt; INSERT INTO fyi_... 2018-01-16, 2770🔥, 0💬

Read Consistency Support in MySQL in MySQL
How Does MySQL Handle Read Consistency in MySQL? Read consistency is a concept that describes how consistent the output will be on two subsequent read operations. A read operation is usually a stand alone SELECT statement or a SELECT subquery in a parent statement. A database server can support up t... 2017-08-03, 2770🔥, 0💬

Database in Use When Dropping a Database in SQL Server
Why I am getting this error when dropping a database in SQL Server? If you are trying to drop a database that is in use, you will get an error message like this: 'Cannot drop database "FyiCenterData" because it is currently in use.' Before dropping a database, you must stop all client sessions using... 2016-11-24, 2770🔥, 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, 2769🔥, 0💬

What Is Index Fragmentation in SQL Server
What Is Index Fragmentation in SQL Server? Index fragmentation is a phenomena where index contents are no longer stored continuously in the storage. When index contents become scattered in the storage, fragmented, performance on index will degrade. If you want to see the fragmentation level of an in... 2016-11-08, 2769🔥, 0💬

Open and Close an Explicit Cursor in Oracle
How To Open and Close an Explicit Cursor in Oracle? An existing cursor can be opened or closed by the OPEN or CLOSE statement as shown in the following sample script: DECLARE CURSOR c_list IS SELECT * FROM countries; CURSOR t_list IS SELECT * FROM employees WHERE employee_id = 100; BEGIN OPEN c_list... 2018-07-22, 2768🔥, 0💬

Mathematical Functions Supported by SQL Server 2005 in SQL Server
What Are the Mathematical Functions Supported by SQL Server 2005 in SQL Server Transact-SQL? SQL Server 2005 supports 23 mathematical functions: ABS, ACOS, ASIN, ATAN, ATN2, CEILING, COS, COT, DEGREES, EXP, FLOOR, LOG, LOG10, PI, POWER, RADIANS, RAND, ROUND, SIGN, SIN, SQRT, SQUARE, and TAN. The ret... 2017-03-22, 2766🔥, 0💬

Understanding and Managing Indexes in SQL Server
Where to find answers to frequently asked questions on Understanding and Managing Indexes in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Understanding and Managing Indexes in SQL Server. Clear answers are provided with tutorial exe... 2016-11-15, 2766🔥, 0💬

<< < … 26 27 28 29 30 31 32 33 34 35 36 … > >>   ∑:1360  Sort:Date

General MySQL Oracle SQL Server