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 2328     Previous     Next
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.
Using xp_ dirtree to List Folders, Subfolders and Files with SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate — Learn how use an undocumented Extended Stored Procedure named xp_dirtree to list folders, subfolders, and files for a given path.
Flyway with Multiple Databases
by Octavia Anghel
Language: Web, Expertise: Intermediate - Learn how to use Flyway with multiple databases.
Turn Off the Index Maintenance of DataTable when you Load Data
by Srinath M S
Language: .NET, Expertise: Intermediate - Learn how to turn indexing on and off when loading data.
Working with an SQL Output Parameter in C#
by Hannes du Preez
Language: .NET, Expertise: Beginner - How to specify the SQL Output parameter's Direction property once you have created it.
Retrieving Specific Information Using the Inspect Docker Command
by Octavia Anghel
Language: Web, Expertise: Intermediate — Learn how to specify the information you want to return by requesting a specific element.
Using Boolean Logic Instead of CASE WHEN
by Hannes du Preez
Language: SQL, Expertise: Intermediate — Once you get the hang of the CASE WHEN SQL Statement it can be easy to overuse it. Sometimes you can simply replace it with Boolean logic.
Encrypting and Decrypting a Database Connection String
by Hannes du Preez
Language: .NET, Expertise: Intermediate — Learn to encrypt your connection string to a database
Enumerating all SQL Servers
by Hannes du Preez
Language: SQL, Expertise: Beginner — Learn how easy it is to enumerate (list) all the possible SQL servers to which you want to connect.
Use SUBSTR to Remove the Last Character from any String in Oracle SQL
by Ben Brumm
Language: SQL, Expertise: Beginner — This code snippet is great for removing trailing slashes or other characters from the end of a string.
Using the SET NOCOUNT SQL Method
by Hannes du Preez
Language: SQL, Expertise: Beginner — Learn how to use the NOCOUNT method to switch off the DONE_IN_PROC messages and boost the performance of queries and network traffic.
How to Convert to a Specific Data Type Using CAST in Oracle SQL
by Ben Brumm
Language: SQL, Expertise: Intermediate — If you need to convert to a specific data type (and length or precision), you can use the CAST function.
Add Months to a Date in Oracle SQL
by Ben Brumm
Language: SQL, Expertise: Beginner — Learn to easily add a number of months to a date in Oracle SQL with the ADD_MONTHS function.
Remove a Constraint from a Table in Oracle SQL
by Ben Brumm
Language: SQL, Expertise: Beginner — Learn how to remove constraints that have been set up to enforce business rules on a database.
21-40 of 2328     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date