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 2338     Previous     Next
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
Knowing the Version and Supported Engines in MySQL
by M S Sridhar
Language: SQL, Level: Intermediate: - These commands are handy to find out the current version and supported engines in the MySQL.
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.
Purging Binary Logs in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Stay out of trouble regarding reaching maximum disk space by purging old logs in MySQL when they are no longer needed.
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.
Understanding Null Values Returned in MySQL
by M S Sridhar
Language: MySQL, Beginner: Intermediate - Learn why the null value often needs special attention in your code to work effectively.
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.
Limiting the Rows Returned in MySQL
by Sridhar M S
Language: SQL, Expertise: Intermediate - In MySQL, LIMIT is a feature that helps fetch a certain number of records matching the criteria provided.
Using the SQL FORMAT Function
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - Learn how to easily format how a field should be displayed.
Using BETWEEN in MySQL Queries
by M S Sridhar
Language: SQL, Expertise: Intermediate - See how to filter a column based on dates and time using BETWEEN.
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.
Making a Column Autoincrement the Value Itself in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to make a column auto-increment the value every time a record is inserted in that table.
Check if a Primary Key Exists on a Table
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to check whether a Primary Key is missing, and if so, add it.
Updating a Column with the Current Time Stamp in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate Learn how to add the current time from the database when updating a column.
Identifying Unused Tables with T-SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to easily identify unused Tables.
Identify Tables with Large Column Counts
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Check out this simple way to identify tables with a large number of columns.
Find Out the Column Name Using the COL_NAME() Function
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Use this code snippet to quickly find out a column's name.
Summing a COUNT Aggregate SQL Function
by Hannes du Preez
Language: SQL, Expertise: Intermediate - See how to sum the result of a count aggregate function.
Using TRY and CATCH Blocks in T-SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to handle errors in T-SQL.
1-20 of 2338     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date