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

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


More articles by Hannes Du Preez

For DevX | June 21, 2018
Check out these two T-SQL methods that determine which version of SQL you are running.
For DevX | June 14, 2018
See how to obtain date differences between larger date ranges in SQL Server 2016.
For DevX | June 7, 2018
Learn more about a simple query to show the contents of your Trigger.
For DevX | May 31, 2018
Learn how to replace strings in SQL.
For DevX | May 24, 2018
Use a query similar to this one to find duplicates in your tables.
For DevX | May 17, 2018
Use this nifty function to check the validity of an email address.
For DevX | May 10, 2018
See how to bypass this SQL error with a simple query.
For DevX | May 3, 2018
Learn the two-step process required to run stored procedures at startup.
For DevX | April 26, 2018
See how to include all values in a date range by using the minus 1 second trick.
For DevX | April 19, 2018
Check out a quick way to access information from the previous row or next row from the current row.
For DevX | April 12, 2018
This query  checks for null values, as well as empty strings, then provides a suitable replacement on either occasion.
For DevX | April 5, 2018
See how to easily get inserted identity in SQL.
For DevX | March 29, 2018
Easily figure out the amount of time spent on a query and the reads and writes of the query in question.
For DevX | March 22, 2018
Learn how to print all column definitions for all the tables in your database.
For DevX | March 15, 2018
Check out this quick way to find all currently blocked requests in SQL.
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date