General MySQL Oracle SQL Server

<< < 1 2 3 4 5 6 7 8 9 10 11 … > >>   ∑:1360  Sort:Date

CHARINDEX() and SUBSTRING() - Locating and Taking Substrings in SQL Server
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-SQL? Transact-SQL is not a language designed for manipulating strings, but it does have two simple functions to locate and take substrings: CHARINDEX() and SUBSTRING(). The tutorial exercise below ass... 2017-03-07, 5124🔥, 0💬

What Is Program Global Area (PGA) in Oracle
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is allocated for each individual database session and it contains session specific information such as SQL statement data or buffers used for sorting. The value specifies the total memory allocated by al... 2020-07-07, 5120🔥, 0💬

Install Oracle Database 10g XE in Oracle
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, OracleXEUniv.exe, the install wizard starts. It will guide you to finish the installation process. You should take notes about: The SYSTEM password you selected: fyicenter. Database server port: 1521. Da... 2024-05-01, 5119🔥, 1💬

What Is SQL Server Transact-SQL (T-SQL)?
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension of the standard SQL (Structured Query Language). Transact-SQL was developed by Microsoft and Sybase. Microsoft's implementation ships in the Microsoft SQL Server product. Sybase uses the language in ... 2017-06-16, 5094🔥, 0💬

"ALTER TABLE ... ALTER COLUMN" - Changing Column Data Type in SQL Server
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Sometimes, you may need to change the data type of an existing column. For example, you want increase the string length of a column. You can use the "ALTER TABLE ... ALTER COLUMN" statements in the followi... 2016-11-15, 5071🔥, 0💬

Getting Help Information from the Server in MySQL
How To Get Help Information from the Server in MySQL? While you are at the "mysql&gt;" prompt, you can get help information from the server by using the "HELP" command. The tutorial exercise below shows sevearal examples: &gt;cd \mysql\bin &gt;mysql -u root mysql&gt; HELP; ... List o... 2018-02-08, 5070🔥, 0💬

Getting Year, Month and Day Out of DATETIME Values in SQL Server
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPART() to get any part of the DATETIME value. But to get year, month and day, you can use 3 specific functions: YEAR(), MONTH() and DAY(). These functions are equivalent to DATEPART() as: YEAR(date) = D... 2017-02-14, 5043🔥, 0💬

GO - Sending a Statement Batch from "sqlcmd" in SQL Server
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to run Transact-SQL statements on a target SQL Server. When "sqlcmd" is started and connected to a SQL Server, it will start a new batch and prompt you to enter the first statement of the batch. You can en... 2016-12-04, 5034🔥, 0💬

Managing Security, Login and User in SQL Server
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Security, Login and User in SQL Server. Clear answers are provided with tutorial exerc... 2016-10-20, 5033🔥, 0💬

CAST() - Converting Numeric Expression Data Types in SQL Server
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? If you want to convert the data type of a numeric expression to a new data type, you can use the CAST(expression AS data_type) function. The tutorial exercise below shows you how to use the CAST() func... 2017-03-27, 5031🔥, 0💬

Updating Multiple Rows with One UPDATE Statement in SQL Server
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDATE statement matches multiple rows, the SET clause will be applied to all matched rows. This rule allows you to update values on multiple rows in a single UPDATE statement. Here is a good example: SELE... 2016-11-02, 5031🔥, 0💬

Generating CREATE VIEW Scripts on Existing Views in SQL Server
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an existing view was created, you can use SQL Server Management Studio to automatically generate a "CREATE VIEW" script The following tutorial shows you how to do this: 1. Run SQL Server Management Studio a... 2016-11-05, 5013🔥, 0💬

CONVERT() - Converting Character Strings to Numeric Values in SQL Server
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need to convert numeric values enclosed in character strings back to numeric values by using the CONVERT() function. When converting character strings to values with CONVERT(), you need to remember two rul... 2017-03-22, 4965🔥, 0💬

IF ... ELSE Statement in SQL Server Transact-SQL
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE statements? You can use IF ... ELSE statements to execute statements under given conditions in Transact-SQL using these syntaxes: IF condition statement_1 IF condition statement_1 ELSE statement_2 IF ... 2017-01-11, 4961🔥, 0💬

Generating CREATE TABLE Script on Existing Tables in SQL Server
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an existing table was created, you can use SQL Server Management Studio to automatically generate a "CREATE TABLE" script The following tutorial shows you how to do this: 1. Run SQL Server Management Stud... 2016-11-17, 4956🔥, 0💬

Concatenating Two Binary Strings in SQL Server
How To Concatenate Two Binary Strings Together in SQL Server Transact-SQL? SQL Server 2005 allows to concatenate two binary strings into a single string with the (+) operator. The following tutorial exercise shows you some binary string concatenation examples: -- Concatenating two binary string lite... 2017-03-07, 4942🔥, 0💬

CREATE, ALTER and DROP Statements in MySQL
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on CREATE, ALTER and DROP Statements in MySQL. Clear answers are provided with tutorial exercises on cr... 2018-03-13, 4929🔥, 0💬

"sys.tables" - Getting a List of All Tables in SQL Server
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table you have just created, you can use the "sys.tables" system view to get a list of all tables in the current database. The tutorial script gives you a good example: SELECT name, type_desc, create_date FR... 2018-03-29, 4928🔥, 1💬

💬 2018-03-29 Eric: That works. Thanks!

DATEDIFF() - Calculating DATETIME Value Differences in SQL Server
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL? If you want to calculate the difference between two date and time values, you can use the DATEDIFF() function in the following format: DATEDIFF(datepart, startdate, enddate) returns INT: "startdate"... 2017-02-20, 4919🔥, 0💬

What Is "mysqld" Command in MySQL
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background on your computer system. Invoking "mysqld" will start the MySQL server on your system. Terminating "mysqld" will shutdown the MySQL server. Here is a tutorial example of invoking "mysqld" with the "--... 2018-06-01, 4915🔥, 0💬

What Is an Oracle Instance in Oracle
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle instance. When a database is started on a database server (regardless of the type of computer), Oracle allocates a memory area called the System Global Area (SGA) and starts one or more Oracle processes.... 2020-11-11, 4906🔥, 0💬

Connect to Oracle Server as SYSDBA in Oracle
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the Oracle server as an administrator is to use SQL*Plus. You need to run SQL*Plus with /nolog option and use the CONNECT with blank user name, blank password and AS SYSDBA option. Here is a sample sessi... 2019-04-03, 4877🔥, 0💬

Drop a Stored Procedure in Oracle
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't want it any more, you can remove it from the database by using the DROP PROCEDURE statement as shown in the following script example: SQL&gt; CREATE PROCEDURE Greeting AS 2 BEGIN 3 DBMS_OUTPUT.PUT_LI... 2018-11-11, 4847🔥, 0💬

What Is an Oracle Tablespace in Oracle
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes. Each tablespace in an Oracle database consists of one or more files called dataf... 2020-10-26, 4833🔥, 1💬

💬 2018-10-15 taj mure: Nicerere

<< < 1 2 3 4 5 6 7 8 9 10 11 … > >>   ∑:1360  Sort:Date

General MySQL Oracle SQL Server