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

Find Out the Column Name Using the COL_NAME() Function

Thu, 12 Oct 2017 03:03:00 -0700 · Language: SQL, Expertise: Intermediate - Use this code snippet to quickly find out a column's name.

Summing a COUNT Aggregate SQL Function

Thu, 05 Oct 2017 03:09:00 -0700 · Language: SQL, Expertise: Intermediate - See how to sum the result of a count aggregate function.

Using TRY and CATCH Blocks in T-SQL

Thu, 28 Sep 2017 03:41:00 -0700 · Language: SQL, Expertise: Intermediate - Learn how to handle errors in T-SQL.

Using FILEPROPERTY to Check for Free Space in a Database

Thu, 21 Sep 2017 03:38:00 -0700 · Language: SQL, Expertise: Intermediate - Learn how to use FILEPROPERTY to check for free space in a database.

Using the Replace Command in MySQL

Wed, 20 Sep 2017 03:03:00 -0700 · Language: SQL, Expertise: Intermediate - The REPLACE command behaves as INSERT when there is no record matching the constraints.

Identify All the Foreign Keys in Your Database

Thu, 14 Sep 2017 03:35:00 -0700 · Language: SQL, Expertise: Intermediate - Learn how to quickly identify all of your foreign keys in a particular database.

Import Large SQL Files into MySQL

Wed, 13 Sep 2017 03:06:00 -0700 · Language: SQL, Expertise: Intermediate - Follow these steps to import large SQL files into MySQL.

Get All Tables Referenced by at Least One View

Thu, 07 Sep 2017 03:30:00 -0700 · Language: SQL, Expertise: Intermediate - The following query will produce a list of tables that are referenced by one or more Views.

Disabling AutoCommit in JDBC

Tue, 05 Sep 2017 01:16:00 -0700 · Language: Java, Expertise: Intermediate - Learn why it is unwise to commit after every insert.

Get Stored Procedure Content and Details

Thu, 31 Aug 2017 03:50:00 -0700 · Language: .NET, Expertise: Intermediate - This query can be used to get details regarding stored procedure content.

SQL JOINs

Wed, 16 Aug 2017 04:32:00 -0700 · Language: Web, Expertise: Intermediate - A JOIN clause is used to combine rows from two or more tables.

Search for Text Inside All the SQL Procedures in Your Database

Thu, 10 Aug 2017 04:36:00 -0700 · Language: SQL, Expertise: Intermediate - Learn how to find all Stored Procedures containing the specific text when you can't remember the name.

Detach from a Docker Container and Leave it Running

Wed, 09 Aug 2017 09:19:00 -0700 · Language: Web, Expertise: Intermediate - Learn a quick way to detach from a Docker container and leave it running.

Identifying Tables Without Primary Keys in SQL

Thu, 03 Aug 2017 04:54:00 -0700 · Language: SQL, Expertise: Intermediate - Use this script to find out which tables in your database(s) do not have Primary Keys.

Get a User that has Deleted Rows with SQL

Thu, 27 Jul 2017 04:52:00 -0700 · Language: SQL, Expertise: Intermediate - Finding a user who has deleted rows is a multi-part process. Get some tips on how to get it done.

Restrict the Connection to a Database in SQL

Thu, 29 Jun 2017 05:05:00 -0700 · Language: SQL, Expertise: Beginner - Learn how to restrict the connection to a database.

The sp_spaceused Procedure in SQL

Thu, 22 Jun 2017 05:02:00 -0700 · Language: SQL, Expertise: Intermediate - See an example of how to use the sp_spaceused special SQL procedure.

Using xp_create_subdir to Create Windows Folders with SQL

Thu, 15 Jun 2017 05:02:00 -0700 · Language: SQL, Expertise: Intermediate - Create folders in T-SQL with the help of the built-in Extended Stored Procedure named xp_create_subdir.

Merge Two DataTables, Preserving the Old Values

Tue, 13 Jun 2017 05:12:00 -0700 · Language: .NET, Expertise: Beginner - Learn how to maintain all the old values when merging two databases.

Using xp_ dirtree to List Folders, Subfolders and Files with SQL

Thu, 01 Jun 2017 05:00:00 -0700 · Language: SQL, Expertise: Intermediate — Learn how use an undocumented Extended Stored Procedure named xp_dirtree to list folders, subfolders, and files for a given path.

Flyway with Multiple Databases

Wed, 31 May 2017 05:00:00 -0700 · Language: Web, Expertise: Intermediate - Learn how to use Flyway with multiple databases.

Turn Off the Index Maintenance of DataTable when you Load Data

Tue, 30 May 2017 05:06:00 -0700 · Language: .NET, Expertise: Intermediate - Learn how to turn indexing on and off when loading data.

Working with an SQL Output Parameter in C#

Thu, 25 May 2017 05:28:00 -0700 · Language: .NET, Expertise: Beginner - How to specify the SQL Output parameter's Direction property once you have created it.

Retrieving Specific Information Using the Inspect Docker Command

Tue, 02 May 2017 06:47:00 -0700 · Language: Web, Expertise: Intermediate — Learn how to specify the information you want to return by requesting a specific element.

Using Boolean Logic Instead of CASE WHEN

Wed, 26 Apr 2017 06:58:00 -0700 · Language: SQL, Expertise: Intermediate — Once you get the hang of the CASE WHEN SQL Statement it can be easy to overuse it. Sometimes you can simply replace it with Boolean logic.


· 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