Daily news, white papers, tutorials and articles on databases.


The links below take you to the DevX: Latest Database Content web site. This is a free off site content service. We're not responsible for the linked content. If nothing displays below, the DevX: Latest Database Content blog or news channel is currently unavailable, please try again later.

DevX: Latest Database Content

www.DevX.com

Knowing the Privileges of the Current User in MySQL Knowing the Privileges of the Current User in MySQL

Fri, 18 Jan 2019 09:54:00 +0000 · Language: SQL, Expertise: Intermediate - See how to figure out what privileges users have in MySQL.

Transfer Data with JSON in SQL Server Transfer Data with JSON in SQL Server

Wed, 16 Jan 2019 09:48:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to transfer data with JSON in SQL Server.

Understanding the Unique Keyword in MySQL Understanding the Unique Keyword in MySQL

Mon, 14 Jan 2019 09:50:00 +0000 · Language: SQL, Expertise: Intermediate - See how to ensure that a certain combination of column values is unique in a table.

Creating an HTML Table with SQL Creating an HTML Table with SQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to produce HTML tables with this SQL example code.

Introducing the APPROX_COUNT_DISTINCT SQL Function Introducing the APPROX_COUNT_DISTINCT SQL Function

Wed, 02 Jan 2019 09:43:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to return the approximate number of unique non-null values in a group.

Auto Start the SQL Server Agent Service Auto Start the SQL Server Agent Service

Fri, 28 Dec 2018 09:54:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to ensure that your SQL Server Agent always restarts when the SQL Server restarts.

Figure Out the Length of Text in a Column in MySQL Figure Out the Length of Text in a Column in MySQL

Wed, 26 Dec 2018 09:40:00 +0000 · Language: SQL, Expertise: Intermediate - See an easy way to find out the length of the text in a column.

Using ENUM in MySQL Columns Using ENUM in MySQL Columns

Fri, 21 Dec 2018 09:46:00 +0000 · Language: SQL, Expertise: Intermediate - See how ENUMs are very powerful definitions and how they help attain data validation when the values are pre-defined.

Reverse Strings in SQL Reverse Strings in SQL

Wed, 19 Dec 2018 09:51:00 +0000 · Language: SQL, Expertise: Intermediate - Learn learn more about a SQL query with which you can reverse strings.

Employ This SQL Stored Procedure to Rename a Column Employ This SQL Stored Procedure to Rename a Column

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - See how to use sp_rename to rename a column in a table.

Selecting the Max, Min and Sum of Values from a Table in MySQL Selecting the Max, Min and Sum of Values from a Table in MySQL

Fri, 07 Dec 2018 09:42:00 +0000 · Language: SQL, Level: Intermediate: - Learn how to find the Max, Min and Sum of values from a column in a table in MySQL.

Generating Random Numbers in SQL Generating Random Numbers in SQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to easily generate a random number.

Getting the Current Date and Time in MySQL Getting the Current Date and Time in MySQL

Mon, 03 Dec 2018 10:08:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to use the NOW() function in MySQL to get the current time and date.

Understanding IFNULL in MySQL Understanding IFNULL in MySQL

Wednesday, December 31, 1969 · Language: MySQL, Expertise: Intermediate - See why IFNULL is a suitable function that can be used where you want to treat null values methodically.

Compress and Decompress SQL Functions Compress and Decompress SQL Functions

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to use compress and decompress in SQL Server 2016.

Using the HASHBYTES Function in SQL Using the HASHBYTES Function in SQL

Wednesday, December 31, 1969 · Learn how to use the hashbytes function in SQL.

Easy One-Step Process to Rename a Table in MySQL Easy One-Step Process to Rename a Table in MySQL

Mon, 12 Nov 2018 09:50:00 +0000 · Language: SQL, Expertise: Intermediate - Learn an easy one-step process for renaming a table in MySQL.

Knowing the Sign of a Given Number in MySQL Knowing the Sign of a Given Number in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - See how to learn the sign of the number for computation purposes.

Know if LIKE Results are True or False Know if LIKE Results are True or False

Mon, 05 Nov 2018 09:45:00 +0000 · Language: SQL, Expertise: Beginner - See how to know if LIKE results are true or false in MySQL.

Learn the Storage Engine Type of a Table in MySQL Learn the Storage Engine Type of a Table in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - There are plenty of commands in MySQL that are supported for particular types of storage engines. Use this command to know the engine type.

Find Indices on a Table in MySQL Find Indices on a Table in MySQL

Wednesday, December 31, 1969 · Language: Enterprise, Expertise: Intermediate - Find the indices on a table in MySQL.

Adding a New Column in a Specific Position Adding a New Column in a Specific Position

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to specify the location of a new column, rather than just adding it to the end of the current table.

Get Detailed Information on Tables in MySQL Get Detailed Information on Tables in MySQL

Fri, 28 Sep 2018 09:18:00 +0000 · Language: SQL, Expertise: Intermediate - See how to get detailed information on available tables, record counts, etc., in MySQL.

Find Tables with an XML Column Find Tables with an XML Column

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - See how to find tables with an XML column.

Finding Duplicate Data Available for Multiple Records Finding Duplicate Data Available for Multiple Records

Mon, 24 Sep 2018 08:20:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to find data available for multiple records with MySQL.


· Home

· Databases

· DevX

· Web Links

· Link to us

· Contact

· What's new

· Site map

· Get Help


Most popular:

· Site Feeds

· Database Design Guide

· Google Sitemaps

· smartDataPump

· Spider Support

· How To Link Properly


Free Tools:

· Sitemap Validator

· Simple Sitemaps

· Spider Spoofer

· Ad & Click Tracking



Search Google
Web Site

Add to My Yahoo!
Syndicate our Content via RSS FeedSyndicate our Content via RSS Feed



To eliminate unwanted email from ALL sources use SpamArrest!






Digg this · Add to del.icio.us · Add to Furl · We Can Help You!




Home · Categories · Articles & Tutorials · Syndicated News, Blogs & Knowledge Bases · Web Log Archives


Top of page

No Ads


Copyright © 2004, 2005 by Smart IT Consulting · Reprinting except quotes along with a link to this site is prohibited · Contact · Privacy