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 252     Previous     Next
What Is Data Integrity?
by Hannes du Preez
Language: SQL, Expertise: Intermediate: Explore what the term data integrity really means.
Finding Object Dependencies in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate: Choose one of these three SQL queries that will return all the database objects that depend on it.
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_.
Recompile a Stored Procedure
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - Learn how to recompile certain stored procedures.
Using DBCC SHRINKDATABASE
by Hannes du Preez
Language: SQL, Expertise: Intermediate: See how to easily shrink the size of the data and log files in a database.
Find Error Log Location
by Hannes du Preez
Language: SQL, Expertise: Intermediate: Learn an easy way to find where your error logs are being stored.
SQL Injection Tips, Part 3
by Hannes du Preez
Language: SQL, Expertise: Intermediate: SQL injection is probably the most common hacking technique out there. Learn more about hacking techniques to keep your data secure.
Get the First Day of the Current Month
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn how to find the first date of the current month.
Get All the Tables with a Count of Their Records
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Use this query to get all the tables with a count of their records.
SQL Injection Tips, Part 2
by Hannes du Preez
Language: SQL, Expertise: Intermediate: Learn more about how to avoid issues with SQL injection.
SQL Injection Tips, Part 1
by Hannes du Preez
Language: SQL, Expertise: Intermediate: Learn more about how to avoid SQL injection issues.
Read All SQL Server Log Files
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn a script that allows you to read through all SQL Server Log files.
SQL Statistic Tests to Look Into
by Hannes du Preez
Language: SQL, Expertise: Beginner: Check out these six tests if you want to explore statistics in SQL.
How to Set hibernate.format_sql in a Spring Boot Application
by Octavia Anghel
Language: Java, Expertise: Intermediate: See how to format the SQL statements for a Spring Boot application.
Working with Multiple Query Windows
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn the best ways to work with multiple query windows in SQL.
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.
1-20 of 252     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date