General MySQL Oracle SQL Server

1 2 3 4 5 6 … > >>   ∑:1341  Sort:Date

Testing Area
What is test testing area for? The testing area is provided to allow visitors to post testing comments. 2016-10-15, 4549220🔥, 11💬

💬 2024-05-01 cvbnm: dfg

💬 2022-05-12 kk: kk kkk

💬 2021-09-19 asc: ggj

(More comments ...)

Oracle Database Tutorials
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for Oracle DBAs and Oracle database application developers. Clear explanations and simple examples provided can be used as learning tutorials or interview preparation guides. It doesn't matter whether yo... 2020-12-02, 51322🔥, 1💬

💬 2017-07-10 sasi: Nice tutorial..

DEFAULT - Providing Default Values to Function Parameters in SQL Server
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parameter when creating a stored procedure, you can provide a default value so that the execution statement is not required to pass input value to this parameter: To define a default value to a parameter wh... 2023-03-03, 33398🔥, 1💬

💬 2023-03-03 yk: ok

Converting Date and Time Values into Integers in SQL Server
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time values be converted into integers? The answer is yes. The resulting integer will be the number days relative the base date: Jan 1, 1900. The time of the day will be rounded to days. But there several ru... 2017-02-22, 30691🔥, 0💬

MySQL Database Tutorials
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for MySQL DBA and MySQL database application developers. Clear explanations and sample scripts provided can be used as learning tutorials or interview preparation guides. It doesn't matter whether you are... 2016-10-16, 30411🔥, 0💬

SQL Server Database Tutorials
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs for SQL Server DBA and SQL Server database application developers. Clear explanations and sample scripts provided can be used as learning tutorials or interview preparation guides. It doesn't matter ... 2016-10-18, 17362🔥, 0💬

Breaking Query Output into Pages in MySQL
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, and you don't want to present all of them to your users on a single page. You can break output into multiple pages, and only present 10 rows per page like what Google Website is doing. To do this, you n... 2022-10-01, 15323🔥, 1💬

💬 2022-10-01 David: MySQL is the best!

AdventureWorksLT - Downloading and Installing the Sample Database in SQL Server
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to practice you DBA skills with the scaled-down version of the sample database AdventureWorksLT provided by Microsoft, you should follow this tutorial to download and install it first: 1. Go to the SQL S... 2019-08-04, 14257🔥, 1💬

💬 2019-08-04 Marc: many thanks

CONTINUE to Next Loop Iteration in SQL Server Transact-SQL
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINUE statements? You can use the CONTINUE statement to continue to the next iteration of a WHILE loop by skipping the rest of statement block of the current iteration using this syntax: WHILE condition B... 2017-01-11, 12109🔥, 0💬

Precision and Rounding of FLOAT Values in SQL Server Transact-SQL
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) should store the mantissa of the floating number in n bits. For example, FLOAT(16) should have a precision one-byte less than FLOAT(24). However, SQL Server Transact-SQL only supports two precisions for... 2017-04-19, 11857🔥, 0💬

Binary Literals in SQL Server Transact-SQL
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are sequences of bytes written in hexadecimal digits with 0x prefixes. Binary literals are used to provide values to binary variables or table columns like BINARY, VARBINARY, IMAGE, etc. Here are some simp... 2017-05-05, 11547🔥, 0💬

Show Current SQL*Plus System Settings in Oracle
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values of SQL*Plus system settings, you can use the SHOW command as shown in the following tutorial exercise: SQL> SHOW AUTOCOMMIT autocommit OFF SQL> SHOW HEADING heading ON SQL> SHOW ... 2020-07-22, 11278🔥, 0💬

Download Oracle Database 10g XE in Oracle
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database 10g Express Edition, visit http://www.oracle.com/technolo gy/software/products/database/ xe/.If you are using Windows systems, there are downloads available for you: Oracle Database 10g Express Edition... 2022-03-22, 11125🔥, 2💬

💬 2022-03-22 Busuhra Saad: download

Calculating Age in Days, Hours and Minutes in SQL Server
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news items or blog articles are displayed with a publishing data and time represented in days, hours and minutes. To do this you can use the DATEDIFF() function with a simple algorithm as shown in the tuto... 2017-02-14, 10770🔥, 0💬

Out-of-Range DATETIME Values in SQL Server Transact-SQL
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIME values, you may get out-of-range errors due to two common mistakes: The date value is a valid calendar date, but it is not in the range covered by DATETIME data type: from January 1, 1753, to Decemb... 2017-04-08, 10257🔥, 0💬

About dba.FYIcenter.com Website
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administrators) and database application developers looking for database server management tips, database programming tutorials, career information, and so on. Just browse through the site, you will find the b... 2016-10-17, 9879🔥, 0💬

AdventureWorksLT Entity Relation Diagram in SQL Server
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in AdventureWorksLT: USE AdventureWorksLT GO SELECT s.name, t.name, t.type_desc FROM sys.tables t, sys.schemas s WHERE t.schema_id = s.schema_id ORDER BY s.name GO s.name t.name t.type_desc dbo BuildVersion USER_... 2016-12-02, 8684🔥, 0💬

bin2hex - Converting Binary Strings into Hexadecimal Character Strings in SQL Server
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns a binary string value to the client tool, it will be displayed by the client tool as hexadecimal digits in a character string format. But they are hexadecimal digits on the display window, not in the... 2018-06-19, 7915🔥, 1💬

💬 2018-06-19 ramesh adhikari: sdafdffddf

Changing Your Own Password in MySQL
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of your own user account, you should use your user account connect to the server "mysql" first. You should then use the "SET PASSWORD ..." command to change the password of the current user account. The... 2021-02-10, 7883🔥, 1💬

Underflow and Overflow of FLOAT Values in SQL Server Transact-SQL
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you enter a floating number that is too big or too small for the FLOAT data type, Transact-SQL will behave as: FLOAT(24) Underflow: If a floating number is too small for FLOAT(24), it will be stored as 0 w... 2017-04-19, 7848🔥, 0💬

Error: Subquery Returns More than 1 Row in MySQL
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDATE statement, it must return exactly one row for each row in the update table that matches the WHERE clause. If it returns multiple rows, MySQL server will give you an error message. To test this out, ... 2018-01-08, 7642🔥, 0💬

SQL Server Transact-SQL Tutorials
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-SQL? I want to know how to write database scripts to run on SQL Server. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team about Microsoft SQL Server Tran... 2023-11-18, 7598🔥, 0💬

Looping through Query Output Rows in MySQL
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and loop through the returning rows is to run the SELECT statement with the mysql_query() function, catch the returning object as a result set, and loop through the result with the mysql_fetch_assoc() func... 2017-06-28, 7467🔥, 0💬

Starting MySQL Server in MySQL
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" program in a command window as shown in the following tutorial: >cd \mysql\bin >mysqld "mysqld" will run quietly without printing any message in you command window. So you will see nothi... 2018-06-12, 7175🔥, 0💬

1 2 3 4 5 6 … > >>   ∑:1341  Sort:Date

General MySQL Oracle SQL Server