General MySQL Oracle SQL Server

<< < … 33 34 35 36 37 38 39 40 41 42 43 … > >>   ∑:1360  Sort:Date

General Rules on Data Consistency in Oracle
What Are the General Rules on Data Consistency in Oracle? Here is a list of general rules on data consistency: All SQL statements always work with a snapshot of the database to provide data consistency. For READ WRITE transactions, the snapshot is taken when each statement starts. For READ ONLY tran... 2019-08-19, 2663🔥, 0💬

What Are User Privileges in MySQL
What Are User Privileges in MySQL? MySQL offers many user privileges to control user accesses to different functions and data objects. Here are some commonly used privileges: ALL - All privileges. CREATE - Allows the user to use CREATE TABLE commands. ALTER - Allows the user to use ALTER TABLE comma... 2017-12-09, 2663🔥, 0💬

Differences of CHAR and NCHAR in SQL Server Transact-SQL
What Are the Differences between CHAR and NCHAR in SQL Server Transact-SQL? Both CHAR and NCHAR are fixed length data types in Transact-SQL. But they have the following main differences: CHAR stores characters based on the code page with 1 byte per character most of the time. NCHAR stores characters... 2017-04-04, 2663🔥, 0💬

Drop an Existing View in MySQL
How To Drop an Existing View in MySQL? If you have an existing view, and you don't want it anymore, you can delete it by using the "DROP VIEW viewName" statement as shown in the following script: mysql&gt; DROP VIEW faqComment; Query OK, 0 rows affected (0.00 sec) mysql&gt; SELECT * FROM faq... 2018-01-24, 2662🔥, 0💬

JSON_SCHEMA_VALIDATION_REPORT() - JSON Schema Validation Report
How to generate a validation report of a JSON value against a JSON schema using the JSON_SCHEMA_VALIDATION_REPORT( )function? JSON_SCHEMA_VALIDATION_REPORT( schema,json) is a MySQL built-in function that returns a validation report of a JSON value against a given JSON schema. The report itself is a ... 2024-11-23, 2661🔥, 0💬

What Are DDL Statements in MySQL
What Are DDL Statements in MySQL? DDL (Data Definition Language) statements are statements to create and manage data objects in the database. The are 3 primary DDL statements: CREATE - Creating a new database object. ALTER - Altering the definition of an existing data object. DROP - Dropping an exis... 2018-03-10, 2661🔥, 0💬

Defining the Name and Server for a new DSN
How To Define the Name and Server for a new DSN? Continuing from the previous tutorial, on the first screen of the "Create a New Data Source to SQL Server" wizard, you should enter 3 fields: Name, Description, and Server as suggested below: Name: FYI_SQL_SERVER Description: FYIcenter.com SQL Server ... 2024-08-06, 2660🔥, 0💬

UNIQUE Constraint Creating Default Index in SQL Server
Does the UNIQUE Constraint Create an Index in SQL Server? If you add the UNIQUE constraint on a column, SQL Server will automatically add a non-clustered index for that column. The tutorial exercise below shows you the index created as part of the UNIQUE column, "id", of "fyi_links": USE FyiCenterDa... 2016-11-13, 2659🔥, 0💬

Run Stored Procedures Interactively in Oracle
How To Run a Stored Procedure Interactively in Oracle? If have an existing stored procedure and you want to run it interactively, the tutorial steps listed below will help you out: Open you connection name, like Local_XE. Open Procedures. Right-click the procedure name: HELLO. Select Run. The Run PL... 2019-01-12, 2658🔥, 0💬

Run SQL Statements with SQL Developer in Oracle
How To Run SQL Statements with Oracle SQL Developer in Oracle? Once a connection is established with an Oracle server, you can enter any SQL statements in the SQL Statement area. Try yourself with the following steps: Go to the SQL Statement area Enter SELECT username, default_tablespace FROM USER_U... 2018-10-08, 2658🔥, 0💬

Retrieve Data from an Explicit Cursor in Oracle
How To Retrieve Data from an Explicit Cursor in Oracle? If you have a cursor opened ready to use, you can use the FETCH ... INTO statement to retrieve data from the cursor into variables. FETCH statement will: Retrieve all the fields from the row pointed by the current cursor pointer and assign them... 2018-07-22, 2658🔥, 0💬

What Is Primary key in MySQL
What Is Primary Key in MySQL? A primary key is a single column or multiple columns defined to have unique values that can be used as row identifications.   ⇒ What Is Foreign Key in MySQL ⇐ What Is Row in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-07, 2658🔥, 0💬

What Is Row in MySQL
What Is Row in MySQL? A row is a unit of data with related data items stored as one item in one column in a table.   ⇒ What Is Primary key in MySQL ⇐ What Is Column in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-15, 2657🔥, 0💬

Verify Time Precision in SQL Server Transact-SQL
How to verify the precession of the server system time in SQL Server Transact-SQL? You can run a WHILE loop to check the precision of server system time in Transact-SQL as shown below: DECLARE @var DATETIME2(7); DECLARE @count INT = 0; WHILE @count&lt;100 BEGIN SET @count = @count + 1; SET @var ... 2017-02-22, 2657🔥, 0💬

Starting SQL Server Browser Service
How To Start SQL Server Browser Service? SQL Server Browser Service is installed as part of the SQL Server. But it is turned off by default to reduce the security risk. If you want start SQL Server Browser Service to allow the SQL Server to accept network connections, you need to follow the steps be... 2024-07-25, 2656🔥, 0💬

Rollback the Current Transaction in Oracle
How To Rollback the Current Transaction in Oracle? If you have used some DML statements updated some data objects, you find a problem with those updates, and you don't want those updates to be permanently recorded in the database, you can use the ROLLBACK statement. It will remove all the database c... 2019-09-04, 2656🔥, 0💬

PL/SQL Procedure in Oracle
What Is a Procedure in Oracle? A procedure is a named program unit. It consists of three parts: Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures. Declaration part is required. Execution Part - Defining execution logic with executable statements... 2018-11-29, 2656🔥, 0💬

Convert Character Types to Numeric Types in Oracle
How To Convert Character Types to Numeric Types in Oracle? You can convert character types to numeric types in two ways: Explicitly by using TO_NUMBER() function. Implicitly by putting character data in a numeric operation. The sample script below shows you how to convert character types to numeric ... 2018-11-17, 2656🔥, 0💬

Performing Comparison on Exact Numbers in SQL Server
How To Perform Comparison on Exact Numbers in SQL Server Transact-SQL? Comparison operations on exact numbers of data types: BIT, INT, NUMERIC, etc., are very easy to understand. Here are some simple examples: -- BIT value comparison DECLARE @x BIT, @y BIT; SET @x = 0; SET @y = 1; SELECT CASE WHEN @... 2017-01-21, 2654🔥, 0💬

Adding a New Index to a Large Table in SQL Server
What Happens If You Add a New Index to Large Table in SQL Server? An index can be added when you create a new table. New rows will be indexed as they are inserted into the table. But you can also add a new index to an existing table with the same CREATE INDEX statement. The existing rows will be ind... 2016-11-13, 2654🔥, 0💬

SINGLE_USER/MULTI_USER - Database User Access Options in SQL Server
How to set database to be SINGLE_USER in SQL Server? Databases in SQL Server have three user access options: MULTI_USER - All users that have the appropriate permissions to connect to the database are allowed. This is the default. SINGLE_USER - One user at a time is allowed to connect to the databas... 2016-11-20, 2653🔥, 0💬

PHP ODBC - Including Date and Time Values in SQL Statements
PHP ODBC - How To Include Date and Time Values in SQL Statements? If you want to provide date and time values in a SQL statement, you should write them in the format of "yyyy-mm-dd hh:mm:ss", and quoted with single quotes ('). The tutorial exercise below shows you two INSERT statements. The first on... 2024-05-05, 2652🔥, 0💬

What Is a SELECT Query Statement in Oracle
What Is a SELECT Query Statement in Oracle? The SELECT statement is also called the query statement. It is the most frequently used SQL statement in any database application. A SELECT statement allows you to retrieve data from one or more tables, or views, with different selection criteria, grouping... 2020-01-04, 2652🔥, 0💬

Data Types Supported in PL/SQL in Oracle
How Many Data Types Are Supported in Oracle? PL/SQL supports two groups of data types: SQL Data Types - All data types used for table columns. PL/SQL Special Data Types - Like BOOLEAN or PLS_INTEGER. The script below shows some data type examples: SQL&gt; set serveroutput on; SQL&gt; DECLARE... 2019-03-20, 2652🔥, 0💬

<< < … 33 34 35 36 37 38 39 40 41 42 43 … > >>   ∑:1360  Sort:Date

General MySQL Oracle SQL Server