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

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, 2551🔥, 0💬

Ways to End the Current Transaction in MySQL
How To End the Current Transaction in MySQL? There are several ways the current transaction can be ended implicitly or explicitly: In "Autocommit On" mode, a single-statement transaction will be ended implicitly when the execution of the statement ends. Changes will be committed. Running the COMMIT ...
2016-10-17, 2551🔥, 0💬

Inner Join with the WHERE Clause in Oracle
How To Write an Inner Join with the WHERE Clause in Oracle? If you don't want to use the INNER JOIN ... ON clause to write an inner join, you can put the join condition in the WHERE clause as shown in the following query example: SQL&gt; SELECT d.department_name, e.first_name, e.last_name 2 FROM...
2019-10-18, 2549🔥, 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, 2549🔥, 0💬

"CREATE LOGIN" - Creating a New Login Name in SQL Server
How To Create a New Login Name in SQL Server in SQL Server? In previous tutorials, it is assumed that you use the "sa" (System Administrator) login name to connect to your SQL Server. But that is not what a normal developer uses to connect to the server, since "sa" has the ALL permissions granted. Y...
2016-10-20, 2549🔥, 0💬

Start Oracle SQL Developer in Oracle
How To Start Oracle SQL Developer in Oracle? To start Oracle SQL Developer, go to \sqldeveloper and click sqldeveloper.exe. The Oracle SQL Developer window shows up. Your copy of Oracle SQL Developer is running now. There will nothing under the Connections icon, because you haven't defined any conne...
2019-02-05, 2548🔥, 0💬

Start Oracle SQL Developer in Oracle
How To Start Oracle SQL Developer in Oracle? To start Oracle SQL Developer, go to \sqldeveloper and click sqldeveloper.exe. The Oracle SQL Developer window shows up. Your copy of Oracle SQL Developer is running now. There will nothing under the Connections icon, because you haven't defined any conne...
2019-02-05, 2548🔥, 0💬

What Are NULL Values in SQL Server
What Are NULL Values in SQL Server Transact-SQL? A NULL value is a special value that represents an unknown value. SQL Server supports NULL values with the following features: All data types used for table columns support NULL values. In another word, NULL values can be stored in database tables. In...
2017-02-05, 2548🔥, 0💬

Numeric Expressions and Functions in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Numeric Expressions and Functions in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Numeric Expressions and Functions in SQL Server Transact-SQL. Clear answers are pr...
2017-04-01, 2547🔥, 0💬

Creating User Defined Functions with Parameters in SQL Server
How To Create User Defined Functions with Parameters in SQL Server Transact-SQL? Very often, you need to create a function with one or more parameters so that the function can be more generic. You only supply values to those parameters at the time of executing the function. User defined functions wi...
2016-12-18, 2546🔥, 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, 2546🔥, 0💬

Assigning New Column Names in a View in SQL Server
How To Assign New Column Names in a View in SQL Server? By default, column names in a view are provided by the underlying SELECT statement. But sometimes, the underlying SELECT statement can not provide names for output columns that specified as expressions with functions and operations. In this cas...
2016-11-03, 2546🔥, 0💬

Differences of CHAR and VARCHAR in SQL Server Transact-SQL
What Are the Differences between CHAR and VARCHAR in SQL Server Transact-SQL? CHAR and VARCHAR are both used to store code page based 1-byte character strings in Transact-SQL. But they have the following main differences: CHAR(n) stores character strings with a fixed length, n bytes, storage format....
2017-04-04, 2545🔥, 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, 2544🔥, 0💬

ICU_VERSION() - ICU (International Components for Unicode) Version
How to obtain the version number of the ICU (International Components for Unicode) library using the ICU_VERSION() function? ICU_VERSION() is a MySQL built-in function that returns the version number of the ICU (International Components for Unicode) library. For example: SELECT ICU_VERSION(); -- +--...
2025-04-11, 2541🔥, 0💬

Configuring ODBC DSN with Different Port Numbers
How To Configure ODBC DSN with Different Port Numbers? If your SQL Server is not using the default port number, like 1269, you need to set the port number to the correct value during the ODBC DSN creation process, as show in this tutorial: 1. Start ODBC Data Source Administrator and click System DSN...
2024-07-25, 2541🔥, 0💬

Working with Database Objects in Oracle PL/SQL
Where to find answers to frequently asked questions on Working with Database Objects in Oracle PL/SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Working with Database Objects in Oracle PL/SQL. Clear answers are provided with tutorial exercis...
2018-10-13, 2541🔥, 0💬

SP_HELP - Viewing Existing Indexes on an Given Table in SQL Server
How To View Existing Indexes on an Given Table using SP_HELP in SQL Server? If you want to know how many indexes have been defined for a given table, you can use the SP_HELP built-in stored procedure in the following syntax: EXEC SP_HELP table_name -- Returns all database objects related the given t...
2016-11-15, 2541🔥, 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, 2540🔥, 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, 2539🔥, 0💬

Define an Anonymous Block in Oracle
How To Define an Anonymous Block in Oracle? An anonymous block must have an execution part, which is a group of other PL/SQL statements enclosed in the BEGIN ... END statement. Here is a script on how to define a simple anonymous block with SQL*Plus: SQL&gt; set serveroutput on; SQL&gt; begi...
2018-10-30, 2539🔥, 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, 2539🔥, 0💬

Use IN Conditions in Oracle
How To Use IN Conditions in Oracle? An IN condition is single value again a list of values. It returns TRUE, if the specified value is in the list. Otherwise, it returns FALSE. Some examples are given in the script below: SELECT CASE WHEN 3 IN (1,2,3,5) THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE S...
2020-03-15, 2538🔥, 0💬

Character String Functions Supported by SQL Server 2005 in SQL Server
What Are the Character String Functions Supported by SQL Server 2005 in SQL Server Transact-SQL? SQL Server 2005 supports 23 character string functions: ASCII(char) - Returning the code value of a non-Unicode character. CHAR(int) - Returning the non-Unicode character of a code value. CHARINDEX(word,...
2017-03-07, 2538🔥, 0💬

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