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


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 2361     Previous     Next
Access Previous Row Value and Next Row Value
by Hannes du Preez
Language: SQL, Level: Beginner: - Check out a quick way to access information from the previous row or next row from the current row.
Quick Tip for Removing Ambiguity in Database Queries
by Srinath M S
Language: SQL, Expertise: Intermediate - Learn why it's helpful to fully qualify database objects so that there is no place for ambiguity.
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.
Finding the Difference Between 2 Dates in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - See which MySQL function computes the difference between two dates and returns a positive result if the first date is greater than the second date.
Quickly Get a List of Database Tables in MySQL
by Srinath M S
Language: SQL, Expertise: Beginner - Execute this command in MySQL to get a list of all tables in the database.
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.
Connecting to a MySQL Database from the Command Prompt
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn an easy way to connect to a MySQL database from the command prompt.
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.
Create a Table from an Existing Table in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to easily create a new table that includes the indexes of the source table.
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.
Suppress Errors When Duplicate Data Is Inserted in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - See how to use INSERT IGNORE in MySQL for cases in which ignoring duplicates might be useful.
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.
Using IFNULL in MySQL
by M S Sridhar
Language: Java, Level: Intermediate: - Check out this MySQL command to handle null effectively in your code.
Allow SQL Server to Silently Truncate Data
by Hannes du Preez
Language: SQL, Expertise: Beginner - See two ways to prevent SQL from throwing this error.
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.
1-20 of 2361     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date