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

Understanding the GRANTS for the Current User in MySQL

Mon, 21 May 2018 02:10:00 -0700 · Language: SQL, Expertise: Intermediate - Learn how to master the GRANT command to have varied output.

Handy Function to Test for Email Validity

Thu, 17 May 2018 02:30:00 -0700 · Language: SQL, Expertise: Intermediate - Use this nifty function to check the validity of an email address.

Bypassing the Row Values Updated or Deleted Error

Thu, 10 May 2018 02:39:00 -0700 · Language: SQL, Expertise: Beginner - See how to bypass this SQL error with a simple query.

Enable SQL Server to Run Stored Procedures at Server Startup

Thu, 03 May 2018 02:07:00 -0700 · Language: SQL, Expertise: Intermediate - Learn the two-step process required to run stored procedures at startup.

How to Include All Values in a Date Range

Thu, 26 Apr 2018 01:12:00 -0700 · Language: SQL, Expertise: Beginner - See how to include all values in a date range by using minus 1 second trick.

Access Previous Row Value and Next Row Value

Thu, 19 Apr 2018 01:18:00 -0700 · Language: SQL, Level: Beginner: - Check out a quick way to access information from the previous row or next row from the current row.

Quick Tip for Removing Ambiguity in Database Queries

Mon, 16 Apr 2018 02:17:00 -0700 · Language: SQL, Expertise: Intermediate - Learn why it's helpful to fully qualify database objects so that there is no place for ambiguity.

How to Check for a NULL Value and an Empty String

Thu, 12 Apr 2018 01:42:00 -0700 · Language: SQL, Expertise: Beginner - This query checks for null values, as well as empty strings, then provides a suitable replacement on either occasion.

Finding the Difference Between 2 Dates in MySQL

Mon, 09 Apr 2018 00:49:00 -0700 · Language: SQL, Expertise: Intermediate - See which MySQL function computes the difference between two dates and returns a positive result if the first date is greater than the second date.

Quickly Get a List of Database Tables in MySQL

Fri, 06 Apr 2018 06:19:00 -0700 · Language: SQL, Expertise: Beginner - Execute this command in MySQL to get a list of all tables in the database.

Easily Get the Inserted Identity in SQL

Thu, 05 Apr 2018 01:14:00 -0700 · Language: SQL, Expertise: Beginner - See how to easily get the inserted identity in SQL.

Statistics IO and Statistics Time

Thu, 29 Mar 2018 02:06:00 -0700 · Language: SQL, Expertise: Intermediate - Easily figure out the amount of time spent on a query and the reads and writes of the query in question.

Connecting to a MySQL Database from the Command Prompt

Mon, 26 Mar 2018 02:02:00 -0700 · Language: SQL, Expertise: Intermediate - Learn an easy way to connect to a MySQL database from the command prompt.

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.

Using IFNULL in MySQL

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.


· 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