General MySQL Oracle SQL Server

<< < … 16 17 18 19 20 21 22 23 24 25 26 … > >>   ∑:1360  Sort:Date

Installing MySQL Server in MySQL
How To Install MySQL Server in MySQL? MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. You can download a copy and install it on your local computer very easily. Here is how you can do this: Go to http://dev.mysql.com/downloads /mysql/5.0.html.Select th... 2018-06-12, 3111🔥, 0💬

OUTPUT - Defining Output Parameters in Stored Procedures in SQL Server
How To Define Output Parameters in Stored Procedures in SQL Server Transact-SQL? Sometime a stored procedure not only want to take input values from the calling statement batch, but it also want to send output values back to the calling statement batch. This can be done by defining output parameters... 2016-12-28, 3109🔥, 0💬

Returning Query Output in XML Format in MySQL
How To Return Query Output in XML Format in MySQL? By default, "mysql" returns query output in text table format. If you want to receive query output in XML format, you need to use the "-X" command option. Here is a good tutorial exercise: &gt;cd \mysql\bin &gt;mysql -u root -X test mysql&am... 2018-04-21, 3108🔥, 0💬

Tables Using CSV Storage Engine in MySQL
How To Create a New Table Using the CSV Storage Engine in MySQL? CSV (Comma-Separated Values) storage engine stores table data in text files in comma-separated value format. CSV is not the default storage engine. You need to specify "ENGINE = CSV" at the end of the "CREATE TABLE" statement to create... 2017-08-13, 3108🔥, 0💬

Variables and Data Types in SQL Server Transact-SQL
Where to find answers to frequently asked questions on variables and data types in Microsoft SQL Server Transact-SQL? I am new to Transact-SQL and SQL Server. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team on variables and data types in Microsoft SQL Se... 2017-04-22, 3108🔥, 0💬

Backup Tables by Copying MyISAM Files in MySQL
How To Backup Tables by Copying MyISAM Table Files in MySQL? To easiest way to backup MyISAM tables is to copy the data files to a backup directory. But this is not the recommended way to do backups. Read the backup FAQ collections for more details. The following tutorial exercise shows you how to a... 2017-09-01, 3106🔥, 0💬

What Is a Statement in SQL Server Transact-SQL
What is a statement in SQL Server Transact-SQL? A statement in SQL Server Transact-SQL is a single smallest execution unit. Here are some examples of Transact-SQL statements: "PRINT 'Hello World!';" - An output statement that print a character string to the console. "SELECT GETDATE();" - A query sta... 2017-05-29, 3106🔥, 0💬

Date and Time Interval Literals in Oracle
How To Write Date and Time Interval Literals in Oracle? Date and time interval literals can coded as shown in the following samples: SELECT DATE '2002-10-03' + INTERVAL '123-2' YEAR(3) TO MONTH FROM DUAL -- 123 years and 2 months is added to 2002-10-03 03-DEC-25 SELECT DATE '2002-10-03' + INTERVAL '... 2020-03-25, 3105🔥, 0💬

User Privilege Tables in MySQL
Where Are User Privileges Stored on the Server in MySQL? MySQL server has a system database, which hosts a number of system tables to system related information like user privileges. Depending on the scope levels, granted user privileges are stored in different tables: "mysql.user" - Stores privileg... 2017-12-09, 3104🔥, 0💬

SQL Server TCP/IP Connection Info
What information is needed for a client tool or application to connect to a SQL Server database using the TCP/IP protocol? In order to connect to a SQL Server database using the TCP/IP protocol, you need to know the following information: 1. Host Name - The name of the hosting computer where the SQL... 2024-08-14, 3103🔥, 0💬

Open a Cursor Variable in Oracle
How To Open a Cursor Variable in Oracle? A cursor variable must be opened with a specific query statement before you can fetch data fields from its data rows. To open a cursor variable, you can use the OPEN ... FOR statement as shown in the following tutorial exercise: CREATE OR REPLACE PROCEDURE FY... 2018-07-18, 3103🔥, 0💬

ODBC Drivers and DSN Configuration for Oracle
Where to find answers to frequently asked questions on ODBC Drivers, DSN Configuration and ASP Connection for Oracle? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team ODBC Drivers, DSN Configuration and ASP Connection for Oracle. Clear answers are pro... 2016-10-15, 3103🔥, 0💬

Difference between CHAR and NCHAR in MySQL
What Are the Differences between CHAR and NCHAR in MySQL? Both CHAR and NCHAR are fixed length string data types. But they have the following differences: CHAR's full name is CHARACTER. NCHAR's full name is NATIONAL CHARACTER. By default, CHAR uses ASCII character set. So 1 character is always store... 2018-01-19, 3101🔥, 0💬

Default Schema of Your Login Session in SQL Server
What Is the Default Schema of Your Login Session in SQL Server? When you login to a SQL Server and select a database to use, SQL Server will assign your login session a default schema. The schema name can be omitted when you refer to objects in the default schema. Here is what you should remember ab... 2016-10-22, 3101🔥, 0💬

Count the Number of Rows with SELECT Statements in Oracle
How To Use SELECT Statement to Count the Number of Rows in Oracle? If you want to count the number of rows, you can use the COUNT(*) function in the SELECT clause. The following select statement returns the number of rows in the "department" table: SQL&gt; SELECT COUNT(*) FROM departments; COUNT... 2019-12-19, 3100🔥, 0💬

Show the Server Version in Oracle
How To Check the Server Version in Oracle? Oracle server version information is stored in a table called: PRODUCT_COMPONENT_VERSION. You can use a simple SELECT statement to view the version information like this: &gt;.\bin\sqlplus Enter user-name: SYSTEM/fyicenter AS SYSDBA Connected to an idle... 2020-09-15, 3099🔥, 0💬

Turn on and off Autocommit in MySQL
How To Switch between Autocommit-On and Autocommit-Off Modes in MySQL? By default, your connection session will be in Autocommit-On mode, where every server executable statement will start a new transaction, and end the transaction when the execution ends. Changes will be committed. So consider this... 2016-10-17, 3097🔥, 0💬

Categories of Data Types in Oracle
How Many Categories of Data Types in Oracle? Oracles supports the following categories of data types: Oracle Built-in Datatypes. ANSI, DB2, and SQL/DS Datatypes. User-Defined Types. Oracle-Supplied Types.   ⇒ Oracle Built-in Data Types in Oracle ⇐ What Is SQL Standard in Oracle ⇑ Understanding SQL ... 2020-05-29, 3096🔥, 0💬

Restore Tables by Copying MyISAM Files in MySQL
How To Restore Tables by Copying MyISAM Table Files in MySQL? If you have old copies of MyISAM table files, you can restore them easily by copying them back to the data directory to replace the current table files. However you may need to shut down MySQL server to do this, because the current table ... 2017-09-01, 3096🔥, 0💬

COLLATE Clause in SQL Server Transact-SQL
How To Specify the Collation for a Character Data Type in SQL Server Transact-SQL? If you do not want to use the default collation provided by the SQL Server, you can use the "COLLATE collation_name" clause to specify a different collation to be used at different levels: Database Level - Used in CRE... 2017-05-13, 3096🔥, 0💬

How Many Anonymous Blocks Can Be Defined in Oracle
How Many Anonymous Blocks Can Be Defined in Oracle? An anonymous block is stored in the user's current session without any name. So you can only define one anonymous block at any time. If you define another anonymous block, the new block will replace the previously defined block, as shown in the fol... 2018-10-30, 3094🔥, 0💬

Oracle Data File - Unit of Physical Storage in Oracle
What Is an Oracle Data File in Oracle? An Oracle data file is a big unit of physical storage in the OS file system. One or many Oracle data files are organized together to provide physical storage to a single Oracle tablespace.   ⇒ Relations between a Tablespace and Data Files in Oracle ⇐ Oracle Ta... 2019-01-20, 3093🔥, 0💬

Understanding PL/SQL Language Basics
Where to find answers to frequently asked questions on Understanding PL/SQL Language Basics? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Understanding PL/SQL Language Basics. It can also be used as learning tutorials on defining variables, ass... 2018-12-26, 3093🔥, 0💬

Export Connection Information to a File in Oracle
How To Export Your Connection Information to a File in Oracle? SQL Developer allows you to export your connection information into an XML file. Here is how to do this: Right-click on Connections Select Export Connection... Enter File Name as: \temp\connections.xml Click OK Open \temp\connections.xml... 2018-10-08, 3093🔥, 0💬

<< < … 16 17 18 19 20 21 22 23 24 25 26 … > >>   ∑:1360  Sort:Date

General MySQL Oracle SQL Server