Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX


More articles by Hannes Du Preez

For DevX | January 8, 2018
Learn this easy way to extract numbers from a string.
For DevX | December 21, 2017
Learn how to disable an index, temporarily or otherwise, with this T-SQL Query.
For DevX | December 14, 2017
See how to use the sp_rename stored procedure if you do not want to drop and recreate the table again.
For DevX | November 29, 2017
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.
For DevX | November 23, 2017
Learn how to easily format how a field should be displayed.
For DevX | November 16, 2017
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.
For DevX | November 10, 2017
Learn how to check whether a Primary Key is missing, and if so, add it.
For DevX | October 26, 2017
Learn how to easily identify unused Tables.
For DevX | October 19, 2017
Check out this simple way to identify tables with a large number of columns.
For DevX | October 12, 2017
Use this code snippet to quickly find out a column's name in SQL.
For DevX | October 5, 2017
See how to sum the result of a count aggregate function.
For DevX | September 28, 2017
Learn how to handle errors in T-SQL in almost the same way as you would in C# or Visual Basic.
For DevX | September 21, 2017
Learn how to use FILEPROPERTY to check for free space in a database.
For DevX | September 14, 2017
Learn how to quickly identify all of your foreign keys in a particular database.
For DevX | September 7, 2017
The following query will produce a list of tables that are referenced by one or more Views.
Thanks for your registration, follow us on our social networks to keep up-to-date