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 - Page 2

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
21-40 of 2366     Previous     Next
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.
Secure Your Data in SQL 2016 with Row Level Security (RLS)
by Srinath M S
Language: SQL, Expertise: Advanced - Learn to implement restrictions on data row access in SQL 2016.
Create a Snapshot of Your Database
by Hannes du Preez
Language: SQL, Level: Intermediate: - Use this code to create a snapshot of your current database.
Identify Tables Without an Identity Column
by Hannes du Preez
Language: SQL, Level: Beginner: - This query will enable you to list all the tables in your database that don't have an IDENTITY column.
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.
21-40 of 2366     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date