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

Determine Which Providers Are Installed on Your Server

Thu, 19 Jul 2018 02:04:00 -0700 · Language: SQL, Expertise: Beginner - See how to check which providers are installed on your server.

Understand Permissions Granted to a User in MySQL

Tue, 17 Jul 2018 03:16:00 -0700 · Language: SQL, Expertise: Intermediate - Learn how to find the permissions available for a given user in MySQL.

Understanding the REPLACE Command in MySQL

Fri, 13 Jul 2018 02:11:00 -0700 · Language: SQL, Expertise: Intermediate - Learn more about an easy way to replace full or partial value in a column.

SET ARITHABORT ON

Thu, 12 Jul 2018 02:11:00 -0700 · Language: SQL, Expertise: Beginner - See why you should use SET ARITHABORT ON.

Import Excel Data into SQL

Fri, 06 Jul 2018 02:04:00 -0700 · Language: SQL, Expertise: Intermediate - Learn about how to read from an Excel Spreadsheet via SQL.

Finding Collations

Thu, 28 Jun 2018 02:12:00 -0700 · Language: SQL, Expertise: Beginner - Learn how to find collations in your tables.

Temporary Tables in MySQL

Fri, 22 Jun 2018 02:08:00 -0700 · Language: SQL, Expertise: Intermediate - See how to use a temporary table in MySQL.

Determine Which Version of SQL You Are Running

Thu, 21 Jun 2018 02:18:00 -0700 · Language: SQL, Expertise: Beginner - Check out these two T-SQL methods that determine which version of SQL you are running.

DateDiff_BIG Function

Thu, 14 Jun 2018 02:11:00 -0700 · Language: SQL, Expertise: Beginner - See how to obtain date differences between larger date ranges in SQL Server 2016.

Understanding the DAYOFWEEK Function in MySQL

Fri, 08 Jun 2018 01:52:00 -0700 · Language: SQL, Expertise: Intermediate - Learn an easy way to figure out the day of the week for a given date.

Display the Contents of a Stored Procedure

Thu, 07 Jun 2018 02:05:00 -0700 · Language: SQL, Expertise: Beginner - Learn more about a simple query to show the contents of your Trigger.

Replacing Strings in Your Output

Thu, 31 May 2018 02:12:00 -0700 · Language: SQL, Expertise: Beginner - Learn how to replace strings in SQL.

Commands to Backup and Restore Data onto a New Database

Tue, 29 May 2018 02:28:00 -0700 · Language: SQL, Expertise: Intermediate - Learn how to easily backup and restore data to a new database in MySQL.

Find Duplicates in Your Table

Thu, 24 May 2018 02:17:00 -0700 · Language: SQL, Expertise: Beginner - Use a query similar to this one to find duplicates in your tables.

Using the STRING_SPLIT Function in SQL Server

Tue, 22 May 2018 02:26:00 -0700 · Language: SQL, Expertise: Intermediate - Explore a way to split a string that is concatenated with a separator.

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.


· 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