General MySQL Oracle SQL Server

<< < … 9 10 11 12 13 14 15 16 17 18 19 … > >>   ∑:1357  Sort:Date

What Are Named Parameters in Oracle
What Are Named Parameters in Oracle? Named parameters are actual parameters specified not by position but by providing formal parameter names when calling the procedure or function. The main advantage of named parameters is that the caller don't have to remember the position of each parameter. But t... 2018-10-13, 3137🔥, 0💬

Selecting Some Specific Columns from a Table in SQL Server
How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly tell the query to return some specific columns, you can specify the column names in the SELECT clause. The following select statement returns only three columns, "id", "created" and "url" from the table... 2016-10-26, 3133🔥, 0💬

Creating a Large Table with Random Data for Indexes in SQL Server
How To Create a Large Table with Random Data for Index Testing in SQL Server? If you want to see how index can be used to improve data search performance, you have to build some large tables, which requires large amount of random data. This tutorial exercise helps you to build a large table with pur... 2016-11-13, 3127🔥, 0💬

Approximate Numeric Data Types in SQL Server Transact-SQL
What are approximate numeric data types supported in SQL Server Transact-SQL? Approximate numeric data types are used to hold numeric values with floating scales. There are 3 different approximate numeric data types supported in SQL Server Transact-SQL: 1. FLOAT - Used to hold values with different ... 2017-04-19, 3126🔥, 0💬

"ALTER INDEX ... REBUILD" - Defragmenting Indexes in SQL Server
How To Rebuild Indexes with ALTER INDEX ... REBUILD in SQL Server? When an index is defragmented to a large percentage, like &gt; 30%, you can use the "ALTER INDEX ... REBUILD" statement to rebuild the index. Here is a tutorial exercise on rebuilding indexes: USE FyiCenterData; GO UPDATE fyi_lin... 2016-11-08, 3125🔥, 0💬

Omitting Columns in INSERT Statements in MySQL
How To Omit Columns with Default Values in INSERT Statement in MySQL? If you don't want to specify values for columns that have default values, or you want to specify values to columns in an order different than how they are defined, you can provide a column list in the INSERT statement. If a column... 2018-01-16, 3119🔥, 0💬

Setting New Values to Parts of a DATETIME Value in SQL Server
How To Set Different Parts of a DATETIME Value in SQL Server Transact-SQL? In SQL Server, you can get different parts of a DATETIME value with the DATEPART() functions. But there is no function that allows you to set different parts to a DATETIME value. For example, you a date_of_birth column as DAT... 2017-02-08, 3116🔥, 0💬

Converting Character Strings to Numeric Values in MySQL
How To Convert Character Strings to Numeric Values in MySQL? You can convert character strings to numeric values by using the CAST(string AS DECIMAL) or CAST(string AS SIGNED INTEGER) function as shown in the following examples: SELECT CAST('4123.45700' AS DECIMAL) FROM DUAL; 4123.46 -- Very poor co... 2018-03-28, 3115🔥, 0💬

Insert Multiple Rows with 1 INSERT Statement in Oracle
How To Insert Multiple Rows with One INSERT Statement in Oracle? If you want to insert multiple rows with a single INSERT statement, you can use a subquery instead of the VALUES clause. Rows returned from the subquery will be inserted the target table. The following tutorial exercise gives a good ex... 2020-01-29, 3113🔥, 0💬

"DISABLE TRIGGER" - Disabling Triggers in SQL Server
How To Disable Triggers using "DISABLE TRIGGER" in SQL Server? If want to stop the execution of an existing trigger temporarily, you can use the "DISABLE TRIGGER" statement to disable it. The disabled trigger will be kept in the database. If you want to resume the execution of a disabled trigger, yo... 2016-10-24, 3112🔥, 0💬

Return Top 5 Rows in Oracle
How To Return Top 5 Rows in Oracle? If you want the query to return only the first 5 rows, you can use the pseudo column called ROWNUM in the WHERE clause. ROWNUM contains the row number of each returning row from the query. The following statement returns the first 5 rows from the employees table: ... 2019-09-16, 3109🔥, 0💬

What Causes Index Fragmentation in SQL Server
What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of existing rows or updating existing values of the indexed column. Inserting new rows should not cause any index fragmentation. This tutorial exercise shows you how update statements of 50000 rows on th... 2016-11-08, 3107🔥, 0💬

Run SQL*Plus Commands in SQL Developer in Oracle
How To Run SQL*Plus Commands in SQL Developer in Oracle? Most of the time, you only run SQL statements in SQL Worksheet, the SQL statement area. But you can also run some SQL*Plus commands in SQL Worksheet. The example below shows you how to run the DECRIBE command in SQL Developer: Go to SQL Worksh... 2018-10-08, 3106🔥, 0💬

Concatenate Two Text Values in Oracle
How To Concatenate Two Text Values in Oracle? There are two ways to concatenate two text values together: CONCAT() function. '||' operation. Here is some examples on how to use them: SELECT 'FYI' || 'Center' || '.com' FROM DUAL; FYICenter.com SELECT CONCAT('FYICenter','.com') FROM DUAL; FYICenter.co... 2019-12-02, 3102🔥, 0💬

What Is SQL in MySQL
What Is SQL in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation.   ⇒ What Is Table in MySQL ⇐ What Is mSQL in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorial... 2017-07-15, 3098🔥, 0💬

sys.sql_modules - Getting Trigger Definitions Back in SQL Server
How To Get the Definition of a Trigger Back in SQL Server? If you want get the definition of an existing trigger back from the SQL Server, you can use the catalog view called sys.sql_modules, which stores definitions of views, stored procedures, and triggers. The sys.sql_modules holds trigger defini... 2016-10-24, 3097🔥, 0💬

Decrementing a Date by 1 in MySQL
How To Decrement Dates by 1 in MySQL? If you have a date, and you want to decrement it by 1 day, you can use the DATE_SUB(date, INTERVAL 1 DAY) function. You can also use the date interval subtraction operation as "date - INTERVAL 1 DAY". The tutorial exercise below gives you some good examples: SEL... 2017-12-26, 3094🔥, 0💬

Managing Oracle Tablespaces and Data Files
Where to find answers to frequently asked questions on Managing Oracle Tablespaces and Data Files? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Oracle Tablespaces and Data Files. Clear answers are provided with tutorial exercises on cr... 2019-04-17, 3093🔥, 0💬

Disk Space Needed for an Export Job in Oracle
How To Estimate Disk Space Needed for an Export Job in Oracle? If you just want to know how much disk space for the dump without actually exporting any data, you can use the ESTIMATE_ONLY=y parameter on the expdp command. The following tutorial exercise shows you how a system user wants to see the d... 2016-10-15, 3092🔥, 0💬

Understanding SQL Language Basics for Oracle
Where to find answers to frequently asked questions on SQL Language Basics for Oracle? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Language Basics for Oracle. Clear answers are provided with tutorial exercises on data types, data literals,... 2020-05-29, 3088🔥, 0💬

Creating Oracle PL/SQL Procedures and Functions
Where to find answers to frequently asked questions on Creating Oracle PL/SQL Procedures and Functions? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Creating Oracle PL/SQL Procedures and Functions. It can also be used as learning tutorials on c... 2018-01-27, 3085🔥, 0💬

Statement Batch in SQL Server Transact-SQL
What is statement batch in SQL Server Transact-SQL? A statement batch is a group of one or more Transact-SQL statements sent at the same time from an application to SQL Server for execution. SQL Server compiles the statements of a batch into a single executable unit, called an execution plan. The st... 2017-05-29, 3085🔥, 0💬

Improving the Trigger to Handle NULL Values in SQL Server
How To Improve the Trigger to Handle NULL Values in SQL Server? When a NULL value is concatenated with a string, the result will be a null value. So if you want the trigger to properly report NULL values, you need to enhance the trigger as shown in the following tutorial example: USE FyiCenterData; ... 2016-10-24, 3081🔥, 0💬

Collation - Character Code Page in SQL Server Transact-SQL
What Is a Collation in SQL Server Transact-SQL? A collation in Transact-SQL is a set of specifications defining a character set and its sorting rules. SQL Server support a large number of built-in collations. For example: Albanian_CI_AI_KS_WS - Albanian, case-insensitive (CI), accent-insensitive (AI... 2017-05-13, 3079🔥, 0💬

<< < … 9 10 11 12 13 14 15 16 17 18 19 … > >>   ∑:1357  Sort:Date

General MySQL Oracle SQL Server