dcsimg
Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
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.


advertisement
Search the Tips

SQL - Page 2

PL/SQL
  SQL
Transact-sql
21-40 of 703     Previous     Next
How to Check for a NULL Value and an Empty String
by Hannes du Preez
Language: SQL, Expertise: Beginner - This query checks for null values, as well as empty strings, then provides a suitable replacement on either occasion.
Easily Get the Inserted Identity in SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to easily get the inserted identity in SQL.
Statistics IO and Statistics Time
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Easily figure out the amount of time spent on a query and the reads and writes of the query in question.
Print All Table Column Definitions in an Entire Database
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to print all column definitions for all the tables in your database.
Finding All Currently Blocked Requests in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Check out this quick way to find all currently blocked requests in SQL.
Understanding UNION in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to identify unique records in MySQL.
Using dm_exec_function_stats in SQL Server 2016
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Check the execution details of a function in SQL.
A Handy Delete Stored Procedure
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Ensure that your data is safe when you make use of Transactions to do any data manipulation with this sample stored procedure.
Identifying all the Index(s) Available on a Table in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn a way to increase performance in MySQL.
Transpose Columns into Rows in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn a different, albeit complicated, way to transpose columns into rows.
Quickest Way to Copy the Structure of a Table
by Hannes du Preez
Language: SQL, Level: Intermediate: - This quick tip demonstrates how to copy a table's data, as well as only the structure of a table.
Create a Snapshot of Your Database
by Hannes du Preez
Language: SQL, Level: Intermediate: - Use this code to create a snapshot of your current database.
Identify Tables Without an Identity Column
by Hannes du Preez
Language: SQL, Level: Beginner: - This query will enable you to list all the tables in your database that don't have an IDENTITY column.
Get the Total Number of Rows for Each Table in Your Database
by Hannes du Preez
Language: SQL, Level: Beginner: - Use the following query to get the total number of rows for each table in your database
Extract All Numbers from a String in SQL
by Hannes du Preez
Language: SQL, Level: Intermediate: - Learn this easy way to extract numbers from a string.
Disable Indexes with SQL
by Hannes du Preez
Language: SQL, Level: Intermediate: - Learn how to disable an index, temporarily or otherwise, with this T-SQL Query.
The sp rename SQL Stored Procedure
by Hannes du Preez
Language: SQL, Level: Intermediate: - See how to use the sp_rename stored procedure if you do not want to drop and recreate the table again.
Pass Comma Separated Values as a Parameter to an SQL Stored Procedure
by Hannes du Preez
Language: SQL, Expertise: Intermediate - 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.
Using the SQL FORMAT Function
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - Learn how to easily format how a field should be displayed.
Create and Schedule an SQL Job
by Hannes du Preez
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.
21-40 of 703     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date