General MySQL Oracle SQL Server

1 2 3 4 5 6 … > >>   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, 47720👍, 7💬

💬 2021-08-04 wendywilson: CRISPR/Cas9 technology has been used as a genome editing tool for a variety of cell lines, including a variety of tumor cells in...

💬 2021-08-01 anand: ghj

💬 2021-03-01 abc: Hello

(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, 11030👍, 1💬

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

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, 10292👍, 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, 6163👍, 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, 5644👍, 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... 2021-03-01, 4583👍, 1💬

Unicode Character String Literals in SQL Server Transact-SQL
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are multi-byte characters. They are very hard to be entered as string literals, because it requires: The SQL client tool to support Unicode characters. The command line tool 'sqlcmd' does not support Unicod... 2019-12-05, 4567👍, 1💬

💬 2019-12-05 gopala krishna: gopala krishna

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, 4346👍, 1💬

Installing PHP on Windows in MySQL
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems is to: Go to http://www.php.net, which is the official Web site for PHP. Download PHP binary version for Windows in ZIP format. Unzip the downloaded file into a directory. You are done. No need to run... 2017-07-30, 4307👍, 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, 4285👍, 1💬

💬 2018-06-19 ramesh adhikari: sdafdffddf

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, 4233👍, 0💬

Verifying PHP Installation in MySQL
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line Interface (CLI) and Common Gateway Interface (CGI). If PHP is installed in the \php directory on your system, you can try this to check your installation: Run "\php\php -v" command to check the Command ... 2017-07-30, 3631👍, 0💬

RAND() - Generating Random Numbers in SQL Server
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers are very useful for generating test data, passwords, or other security related data. SQL Server 2005 offers you the random number generator function RAND in two format: RAND(seed) - Starting a new sequ... 2017-03-11, 3519👍, 0💬

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, 3502👍, 0💬

sys.procedures - Listing All Stored Procedures in SQL Server
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to see a list of stored procedures in your current database, you can use the system view, sys.procedures as shown in this tutorial exercise: USE FyiCenterData; GO SELECT * FROM sys.procedures; GO Name o... 2017-01-05, 3270👍, 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, 2994👍, 0💬

sys.server_principals - Listing All Login Names in SQL Server
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login names defined on the server, you can use the system view, sys.server_principals as shown in this tutorial exercise: -- Login with sa SELECT name, sid, type, type_desc FROM sys.server_principals WHERE type... 2016-10-20, 2987👍, 0💬

Error: Imported Table Already Exists in Oracle
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a table that already exists, the Data Pump Import utility will return an error and skip this table. The following exercise shows you a good example: >cd \oraclexe\app\oracle\product\1 0.2.0\serve... 2016-10-15, 2887👍, 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, 2867👍, 0💬

sys.database_principals - Listing All User Names in SQL Server
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names defined in a database, you can use the system view, sys.database_principals as shown in this tutorial exercise: -- Login with sa -- Select a database USE FyiCenterData; GO -- List all user names SELEC... 2017-08-25, 2803👍, 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, 2782👍, 0💬

DATEADD() Function Usage Examples in SQL Server
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for manipulating date and time values. The following tutorial exercise shows you some good DATEADD() usage examples: -- Incrementing 1 year on a leap date DECLARE @birth_date DATETIME; SET @birth_date = '20... 2017-02-20, 2780👍, 0💬

ROUND() - Rounding Values to Specific Precisions in SQL Server
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need to round a numeric value to a specific precision. For example, you may want to round values in your financial statement to the precision of 1000.00. This can be done by the ROUND() function with the f... 2017-03-11, 2731👍, 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, 2591👍, 0💬

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

General MySQL Oracle SQL Server