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 2321     Previous     Next
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.
Using FILEPROPERTY to Check for Free Space in a Database
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to use FILEPROPERTY to check for free space in a database.
Using the Replace Command in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - The REPLACE command behaves as INSERT when there is no record matching the constraints.
Identify All the Foreign Keys in Your Database
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to quickly identify all of your foreign keys in a particular database.
Import Large SQL Files into MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Follow these steps to import large SQL files into MySQL.
Get All Tables Referenced by at Least One View
by Hannes du Preez
Language: SQL, Expertise: Intermediate - The following query will produce a list of tables that are referenced by one or more Views.
Disabling AutoCommit in JDBC
by M S Sridhar
Language: Java, Expertise: Intermediate - Learn why it is unwise to commit after every insert.
Get Stored Procedure Content and Details
by Hannes du Preez
Language: .NET, Expertise: Intermediate - This query can be used to get details regarding stored procedure content.
SQL JOINs
by Octavia Anghel
Language: Web, Expertise: Intermediate - A JOIN clause is used to combine rows from two or more tables.
Search for Text Inside All the SQL Procedures in Your Database
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to find all Stored Procedures containing the specific text when you can't remember the name.
Detach from a Docker Container and Leave it Running
by Octavia Anghel
Language: Web, Expertise: Intermediate - Learn a quick way to detach from a Docker container and leave it running.
Identifying Tables Without Primary Keys in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Use this script to find out which tables in your database(s) do not have Primary Keys.
Get a User that has Deleted Rows with SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Finding a user who has deleted rows is a multi-part process. Get some tips on how to get it done.
Restrict the Connection to a Database in SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn how to restrict the connection to a database.
The sp_spaceused Procedure in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - See an example of how to use the sp_spaceused special SQL procedure.
Using xp_create_subdir to Create Windows Folders with SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Create folders in T-SQL with the help of the built-in Extended Stored Procedure named xp_create_subdir.
Merge Two DataTables, Preserving the Old Values
by Srinath M S
Language: .NET, Expertise: Beginner - Learn how to maintain all the old values when merging two databases.
1-20 of 2321     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date