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


Print All Table Column Definitions in an Entire Database

Thu, 22 Mar 2018 02:03:00 -0700 · Language: SQL, Expertise: Intermediate - Learn how to print all column definitions for all the tables in your database.

Create a Table from an Existing Table in MySQL

Fri, 16 Mar 2018 02:04:00 -0700 · Language: SQL, Expertise: Intermediate - Learn how to easily create a new table that includes the indexes of the source table.

Finding All Currently Blocked Requests in SQL

Thu, 15 Mar 2018 02:01:00 -0700 · Language: SQL, Expertise: Intermediate - Check out this quick way to find all currently blocked requests in SQL.

Understanding UNION in MySQL

Mon, 12 Mar 2018 02:06:00 -0700 · Language: SQL, Expertise: Intermediate - Learn how to identify unique records in MySQL.

Using dm_exec_function_stats in SQL Server 2016

Thu, 08 Mar 2018 02:10:00 -0800 · Language: SQL, Expertise: Intermediate - Check the execution details of a function in SQL.

Suppress Errors When Duplicate Data Is Inserted in MySQL

Tue, 06 Mar 2018 02:04:00 -0800 · Language: SQL, Expertise: Intermediate - See how to use INSERT IGNORE in MySQL for cases in which ignoring duplicates might be useful.

A Handy Delete Stored Procedure

Thu, 01 Mar 2018 02:07:00 -0800 · Language: SQL, Expertise: Intermediate - Ensure that your data is safe when you make use of Transactions to do any data manipulation with this sample stored procedure.


Tue, 27 Feb 2018 02:04:00 -0800 · Language: Java, Level: Intermediate: - Check out this MySQL command to handle null effectively in your code.

Allow SQL Server to Silently Truncate Data

Thu, 22 Feb 2018 01:08:00 -0800 · Language: SQL, Expertise: Beginner - See two ways to prevent SQL from throwing this error.

Identifying all the Index(s) Available on a Table in MySQL

Tue, 20 Feb 2018 02:02:00 -0800 · Language: SQL, Expertise: Intermediate - Learn a way to increase performance in MySQL.

Transpose Columns into Rows in SQL

Thu, 15 Feb 2018 02:09:00 -0800 · Language: SQL, Expertise: Intermediate - Learn a different, albeit complicated, way to transpose columns into rows.

Quickest Way to Copy the Structure of a Table

Thu, 08 Feb 2018 02:06:00 -0800 · Language: SQL, Level: Intermediate: - This quick tip demonstrates how to copy a table's data, as well as only the structure of a table.

Secure Your Data in SQL 2016 with Row Level Security (RLS)

Wed, 07 Feb 2018 02:03:00 -0800 · Language: SQL, Expertise: Advanced - Learn to implement restrictions on data row access in SQL 2016.

Create a Snapshot of Your Database

Thu, 01 Feb 2018 02:01:00 -0800 · Language: SQL, Level: Intermediate: - Use this code to create a snapshot of your current database.

Identify Tables Without an Identity Column

Thu, 25 Jan 2018 02:35:00 -0800 · Language: SQL, Level: Beginner: - This query will enable you to list all the tables in your database that don't have an IDENTITY column.

Get the Total Number of Rows for Each Table in Your Database

Thu, 18 Jan 2018 02:33:00 -0800 · Language: SQL, Level: Beginner: - Use the following query to get the total number of rows for each table in your database

Knowing the Version and Supported Engines in MySQL

Fri, 12 Jan 2018 06:06:00 -0800 · Language: SQL, Level: Intermediate: - These commands are handy to find out the current version and supported engines in the MySQL.

Extract All Numbers from a String in SQL

Mon, 08 Jan 2018 02:34:00 -0800 · Language: SQL, Level: Intermediate: - Learn this easy way to extract numbers from a string.

Disable Indexes with SQL

Thu, 21 Dec 2017 05:36:00 -0800 · Language: SQL, Level: Intermediate: - Learn how to disable an index, temporarily or otherwise, with this T-SQL Query.

Purging Binary Logs in MySQL

Mon, 18 Dec 2017 05:14:00 -0800 · Language: SQL, Expertise: Intermediate - Stay out of trouble regarding reaching maximum disk space by purging old logs in MySQL when they are no longer needed.

The sp rename SQL Stored Procedure

Thu, 14 Dec 2017 14:22:00 -0800 · Language: SQL, Level: Intermediate: - See how to use the sp_rename stored procedure if you do not want to drop and recreate the table again.

Understanding Null Values Returned in MySQL

Thu, 07 Dec 2017 01:23:00 -0800 · Language: MySQL, Beginner: Intermediate - Learn why the null value often needs special attention in your code to work effectively.

Pass Comma Separated Values as a Parameter to an SQL Stored Procedure

Wed, 29 Nov 2017 02:35:00 -0800 · Language: SQL, Expertise: Intermediate - There will be times when you need to pass a list of values as a singular parameter to an SQL Stored Procedure. Problem is: SQL doesn't support this. See how to get around this issue.

Limiting the Rows Returned in MySQL

Tue, 28 Nov 2017 13:21:00 -0800 · Language: SQL, Expertise: Intermediate - In MySQL, LIMIT is a feature that helps fetch a certain number of records matching the criteria provided.

Using the SQL FORMAT Function

Thu, 23 Nov 2017 02:31:00 -0800 · Language: SQL, Expertise: Intermediate - Learn how to easily format how a field should be displayed.

· 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