General MySQL Oracle SQL Server

<< < … 7 8 9 10 11 12 13 14 15 16 17 … > >>   ∑:1363  Sort:Date

Creating Multi-Statement Table-Value Functions in SQL Server
How To Create an Multi-Statement Table-Valued Function in SQL Server Transact-SQL? To create a multi-statement table-valued function, you need to define a temporary table as the returning table in the function. INSERT statements should be used to insert data into the returning table. The tutorial ex... 2016-10-17, 4165🔥, 0💬

Requirements for Using MySQL in PHP in MySQL
What Do You Need to Connect PHP to MySQL in MySQL? If you want to access MySQL database server in your PHP script, you need to make sure that a MySQL API module (extension) is installed and turned on in your PHP engine. PHP 5 now supports two MySQL API extensions: mysql - This is the standard MySQL ... 2017-07-30, 4161🔥, 0💬

INET6_NTOA() - IPv6 Address Number to String
How to convert an IPv6 address from number format to string using the INET6_NTOA() function? INET6_NTOA(int) is a MySQL built-in function that converts an IPv6 address from number format to string. For example: SET @ipv6 = UNHEX('FDFE0000000000005A55CAF FFEFA9089');SELECT HEX(@ipv6), INET6_NTOA(@ipv... 2026-02-02, 4153🔥, 0💬

Suser_Sname() - Sever Level Security Principal of Your Session in SQL Server
What Is the Security Principal at the Server Level That Represents Your Session in SQL Server? Security principal identifies who you are when you interact with the SQL Server. What can do you at the server level solely depends on the security principal that represents you. So it is very important to... 2016-10-20, 4149🔥, 0💬

Show Storage Engines Supported in MySQL in MySQL
How To See Which Storage Engines Are Supported in Your MySQL Server in MySQL? If you want to know exactly which storage engines are supported in your MySQL server, you can run the "SHOW ENGINES" command as shown in the tutorial example below: mysql&gt; SHOW ENGINES; +------------+---------+-----. .. 2017-08-08, 4145🔥, 0💬

PS_THREAD_ID() - PS Thread ID of Given Connect
How to obtain the performance schema thread id of a given connection using the PS_THREAD_ID() function? PS_THREAD_ID(con) is a MySQL built-in function that returns the performance schema thread id of a given connection. For example: SELECT CONNECTION_ID(); -- +-----------------+ -- | CONNECTION_ID()... 2025-02-16, 4142🔥, 0💬

Using User Defined Functions in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Using User Defined Functions in SQL Server Transact-SQL. Clear answers are provided wit... 2016-12-28, 4136🔥, 0💬

Connect SQL*Plus Session to Oracle Server in Oracle
How To Connect a SQL*Plus Session to an Oracle Server in Oracle? In order to connect a SQL*Plus session to an Oracle server, you need to: 1. Obtain the connection information from the Oracle server DBA. 2. Define a new "connect identifier" called "FYI_XE" in your tnsnames.org file with the given con... 2020-08-13, 4123🔥, 0💬

Casting Strings to Wrong Code Pages in SQL Server Transact-SQL
What Happens If Strings Are Casted into Wrong Code Pages in SQL Server Transact-SQL? In SQL Server, different collations may use different code pages. For example: Albanian_CI_AI_KS_WS - Albanian, Code page 1250. Arabic_CI_AS_KS_WS - Arabic, Code page 1256. French_CI_AI - French, Code page 1252. Kor... 2017-05-13, 4121🔥, 0💬

Indexes for the PRIMARY KEY Column in Oracle
What Is an Index Associated with a Constraint in Oracle? An index associated with a constraint because this constraint is required to have an index. There are two types of constraints are required to have indexes: UNIQUE and PRIMARY KEY. When you defines a UNIQUE or PRIMARY KEY constraint in a table... 2019-05-01, 4113🔥, 0💬

sys.trigger_events - Event List of an Existing Trigger in SQL Server
How To See the Event List of an Existing Trigger using sys.trigger_events in SQL Server? If what are the DML events an existing trigger is handling, you can use the catalog view, sys.trigger_events. You need to join sys.trigger_events and sys.triggers to get a better list as shown in this tutorial e... 2016-10-24, 4108🔥, 0💬

Counting Duplicated Values in a Column in MySQL
How To Count Duplicated Values in a Column in MySQL? If you have a column with duplicated values, and you want to know what are those duplicated values are and how many duplicates are there for each of those values, you can use the GROUP BY ... HAVING clause as shown in the following example. It ret... 2017-10-16, 4099🔥, 0💬

Incrementing or Decrementing Parts of DATETIME Values in SQL Server
How To Increment or Decrement Parts of DATETIME Values in SQL Server Transact-SQL? If you want to increment or decrement one part of a date and time value, you can use the DATEADD() function in the following format: DATEADD(datepart, number, date) returns DATETIME: "date" - the input date "number" -... 2017-02-20, 4082🔥, 0💬

Managing Oracle User Accounts, Schema and Privileges
Where to find answers to frequently asked questions on Managing Oracle User Accounts, Schema and Privileges? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Oracle User Accounts, Schema and Privileges. Clear answers are provided with tuto... 2019-07-30, 4079🔥, 0💬

Shutdown 10g XE Server in Oracle
How To Shutdown Your 10g XE Server in Oracle? If you want to shutdown your 10g Express Edition server, go to the Services manager in the control panel. You will a service called OracleServiceXE, which represents your 10g Express Edition server. Select OracleServiceXE, and use the right mouse click t... 2020-10-10, 4077🔥, 0💬

Sample Databases Are Provided by Microsoft in SQL Server
What Sample Scripts and Sample Databases Are Provided by Microsoft in SQL Server? In order to help you to learn SQL Server, Microsoft provides several free sample scripts and sample databases. SqlServerSamples.msi - 25,469 KB: Sample scripts. AdventureWorksDB.msi - 28,053 KB: Sample OLTP database: A... 2016-12-04, 4077🔥, 0💬

Character String Data Types in MySQL
What Are Character String Data Types in MySQL? MySQL supports the following string data types: CHAR(n) same as CHARACTER(n) - Fixed width and " " padded characters strings. Default character set is ASCII. NCHAR(n) same as NATIONAL CHARACTER(n) - Fixed width and " " padded character strings with UTF8... 2018-04-12, 4076🔥, 0💬

Change SQL*Plus System Settings in Oracle
How To Change SQL*Plus System Settings in Oracle? SQL*Plus environment is controlled a big list of SQL*Plus system settings. You can change them by using the SET command as shown in the following list: SET AUTOCOMMIT OFF - Turns off the auto-commit feature. SET FEEDBACK OFF - Stops displaying the "2... 2020-07-22, 4068🔥, 0💬

Transaction Isolation Levels in MySQL
What Are Transaction Isolation Levels in MySQL? There are 4 transaction isolation levels defined by SQL-1992 standard: READ UNCOMMITTED - The SELECT statements in one transaction will read uncommitted data changes from transactions of all connected sessions. In this level, "dirty read" could happen,... 2017-08-03, 4064🔥, 0💬

Testing New User Account and Password in MySQL
How To Test a New User Account and Password in MySQL? If you have new user created with a password, you test it using "mysql" program with the "-u" and "-p" options. The following tutorial exercise shows you some interesting use cases of connecting to the server with user names and passwords: &g... 2017-09-08, 4055🔥, 0💬

Installing Sample Scripts and Databases in SQL Server
Where to find answers to frequently asked questions on Installing Sample Scripts and Databases in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Installing Sample Scripts and Databases in SQL Server. Clear answers are provided with tu... 2016-12-04, 4053🔥, 0💬

Assign Query Results to Variables in Oracle
How To Assign Query Results to Variables in Oracle? If you want to assign results from SELECT statements to variables, you can use the INTO clause, which an extension of SELECT statements for PL/SQL. The sample code below shows some good example on INTO clause: DECLARE total NUMBER; now DATE; fname ... 2018-09-24, 4050🔥, 0💬

Error: Exact Fetch Returns More Rows in Oracle
Can You Assign Multiple Query Result Rows To a Variable in Oracle? You can use "SELECT ... INTO variable" to assign query results to variables. But what happens if the SELECT statements return multiple rows? The answer is that you will get a run time error. The following tutorial exercise shows this... 2018-09-24, 4049🔥, 0💬

Converting Integers into Date and Time Values in SQL Server
Can Integers Be Converted into Date and Time Values in SQL Server Transact-SQL? Can integers be converted into date and time values? The answer is yes. The input integer will be used as the number of days relative to the base date: Jan 1, 1900. The time of the day will be set to 0, midnight of the d... 2017-02-22, 4049🔥, 0💬

<< < … 7 8 9 10 11 12 13 14 15 16 17 … > >>   ∑:1363  Sort:Date

General MySQL Oracle SQL Server