Subscribe: DevX: Latest Database Content
http://services.devx.com/outgoing/databasefeed.xml
Preview: DevX: Latest Database Content

DevX: Latest Database Content



www.DevX.com



Published: Thu, 23 Nov 2017 20:36:29 -0800

Last Build Date: Thu, 23 Nov 2017 20:36:29 -0800

 



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.



Using BETWEEN in MySQL Queries

Wed, 22 Nov 2017 02:49:00 -0800

Language: SQL, Expertise: Intermediate - See how to filter a column based on dates and time using BETWEEN.



Create and Schedule an SQL Job

Thu, 16 Nov 2017 10:06:00 -0800

Language: SQL, Expertise: Intermediate - Sometimes you want a certain query, or Stored Procedure to be repeated on a daily, weekly or monthly basis. Learn to create an SQL Job and schedule it.



Making a Column Autoincrement the Value Itself in MySQL

Wed, 15 Nov 2017 02:47:00 -0800

Language: SQL, Expertise: Intermediate - Learn how to make a column auto-increment the value every time a record is inserted in that table.



Check if a Primary Key Exists on a Table

Fri, 10 Nov 2017 02:27:00 -0800

Language: SQL, Expertise: Intermediate - Learn how to check whether a Primary Key is missing, and if so, add it.



Updating a Column with the Current Time Stamp in MySQL

Fri, 27 Oct 2017 02:05:00 -0700

Language: SQL, Expertise: Intermediate Learn how to add the current time from the database when updating a column.



Identifying Unused Tables with T-SQL

Thu, 26 Oct 2017 02:47:00 -0700

Language: SQL, Expertise: Intermediate - Learn how to easily identify unused Tables.



Identify Tables with Large Column Counts

Thu, 19 Oct 2017 03:22:00 -0700

Language: SQL, Expertise: Intermediate - Check out this simple way to identify tables with a large number of columns.



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.