dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips

SQL

PL/SQL
  SQL
Transact-sql
1-20 of 269     Previous     Next
Selecting All Columns, Separated with Commas
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to get a nicely comma-separated list of column names.
How to Pass Parameters in @Query
by Octavia Anghel
Language: Java, Expertise: Intermediate - Learn how to pass parameters to an SQL query written with @Query via @Param or positional parameters.
Object Explorer Details
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to use the Object Explorer feature in SQL to find a particular stored procedure from a long list of available options.
Using Multi Edit Mode
by Hannes du Preez
Language: SQL, Expertise: Beginner - When dealing with large lists of information, we, as developers, sometimes need to copy them, then add commas manually. See a neat trick to automatically add the required commas.
Get All Columns in All Tables of a Specific Data Type
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to find a specific data type across all tables and columns in a database.
3 More Hints for Building Faster SQL Queries
by Hannes du Preez
Language: SQL, Expertise: Beginner - Follow these three tips to help improve your SQL query performance.
Creating an SQL Query that Generates Dynamic LIKE Statements
by Hannes du Preez
Language: SQL, Expertise: Intermediate - See how to construct a query that can generate dynamic LIKE statements in SQL.
3 Hints for Achieving Faster SQL Queries
by Hannes du Preez
Language: SQL, Expertise: Beginner - Follow these three tips to help increase the performance of your SQL queries.
Understanding TOP WITH TIES in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - See what the Top with Ties clause actually does in SQL>
Difference Between RANK, DENSE_RANK and ROW_NUMBER SQL Statements
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn more about how to use three very different SQL statements.
Three Levels of Data Abstraction in SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn more about the levels of data abstraction employed in SQL to hide irrelevant details from users.
Delete Data Safely with SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Explore to how to safely delete data in SQL.
Name All of the Normalization Forms in SQL
by Hannes du Preez
Language: Java, Expertise: Beginner - Explore a list of the names of all normalization forms in SQL.
Discovering the Reason for Poor Query Performance
by Hannes du Preez
Language: SQL, Expertise: Beginner - Explore some of the reasons why your query performance might not by up to expected speeds.
Types of Indexes that Exist in SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - Get an overview of the index types available in SQL.
T-SQL Performance Tip: Stored Procedure Names
by Hannes du Preez
Language: SQL, Expertise: Beginner - See why you should avoid prefixing your Stored Procedure names with sp_.
T-SQL Performance Tip: NOT IN vs NOT EXISTS
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn the difference between using not in and not exists in T-SQL.
User Creation and Scenarios
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn more about the importance of providing a password during the user creation process itself.
T-SQL Performance Tip: The * Operator
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn more about why you should use explicit column names in T-SQL.
T-SQL Performance Tip: Owner or Schema Name
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn more about how to improve query performance by including owner or schema name.
1-20 of 269     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date