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 - 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 2406     Previous     Next
Improve Performance of Select Queries with LIMIT Keyword in MySQL
by Srinath M S
Language: Enterprise, Expertise: Intermediate - Learn a simple trick to make certain queries perform correctly in MySQL.
Fetching Common Records Between Two Tables
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to fetch records that are common to one or more tables.
Optimize Your SQL Queries with Schema Names
by Srinath M S
Language: SQL, Expertise: Intermediate - Learn how to make possible for the query plan cache to be reused by all users.
Replace Spaces and New Lines with One SQL Statement
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn an easy way to replace new lines and spaces inside a field.
Setting a Default NULL Date in SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how easy it is to set a Default NULL Date in SQL.
Determine Which Providers Are Installed on Your Server
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to check which providers are installed on your server.
Understand Permissions Granted to a User in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to find the permissions available for a given user in MySQL.
Understanding the REPLACE Command in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn more about an easy way to replace full or partial value in a column.
SET ARITHABORT ON
by Hannes du Preez
Language: SQL, Expertise: Beginner - See why you should use SET ARITHABORT ON.
Import Excel Data into SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn about how to read from an Excel Spreadsheet via SQL.
Finding Collations
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn how to find collations in your tables.
Temporary Tables in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - See how to use a temporary table in MySQL.
Determine Which Version of SQL You Are Running
by Hannes du Preez
Language: SQL, Expertise: Beginner - Check out these two T-SQL methods that determine which version of SQL you are running.
DateDiff_BIG Function
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to obtain date differences between larger date ranges in SQL Server 2016.
Understanding the DAYOFWEEK Function in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn an easy way to figure out the day of the week for a given date.
Display the Contents of a Stored Procedure
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn more about a simple query to show the contents of your Trigger.
Replacing Strings in Your Output
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn how to replace strings in SQL.
Commands to Backup and Restore Data onto a New Database
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to easily backup and restore data to a new database in MySQL.
Find Duplicates in Your Table
by Hannes du Preez
Language: SQL, Expertise: Beginner - Use a query similar to this one to find duplicates in your tables.
Using the STRING_SPLIT Function in SQL Server
by Srinath M S
Language: SQL, Expertise: Intermediate - Explore a way to split a string that is concatenated with a separator.
21-40 of 2406     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date