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


advertisement
Search the Tips
Tip Bank > Database Development

Database Development

Active Server Pages
Data Access
Database Administration
Database Apis
  ADO   ADOX   JDBC   ODBC   OLE DB   SQL-DMO
Database Tuning
DB2
Informix
MySQL
Oracle
Relational Databases
SQL
  PL/SQL   Transact-sql
Sql Server
Visual Foxpro
1-20 of 377     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.
Locking a User Account in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - MySQL provides a mechanism to alter the user properties, thereby allowing you to lock the user account.
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.
Understanding the Behavior of the AUTO_INCREMENT Column in MySQL
by Sridhar M S
Language: MySQL, Expertise: Intermediate - Auto_Increment can be tricky to use in MySQL, learn more about how it works.
Set Up a Database Dialect in Spring Boot
by OCTAVIA ANGHEL
Language: Java, Expertise: Intermediate - Learn how to use the spring.jpa.properties.hibernate.dialect property to set the database dialect in Spring Boot.
Using MICROSECOND in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Developers often work with time in terms of hours, minutes and seconds. Learn how to break it down to the microsecond level.
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.
Finding the Current Quarter in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to use MySQL to find the current financial quarter.
Using ENUM to Pre-define Column Values in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how the values for a particular column can be pre-defined during the table definition. These values will be validated when the records are inserted or updated in the table.
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.
Converting UNIX_TIMESTAMP to Readable Format in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn more about a quick and neat way of converting the current time from Unix format to Readable format.
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.
1-20 of 377     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date