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 3

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
41-60 of 2259     Previous     Next
Trigger Efficiency in Oracle
by Alexander Ocher
It turns out that the latest documentation for Oracle 10g and 11g is incorrect and the documentation for Oracle 9i and previous releases is correct: AFTER row triggers are more efficient than BEFORE row triggers.
Obtain Information About Table Columns in Microsoft SQL Server
by Alexander Ocher
To obtain information about table columns in Microsoft SQL Server, use the INFORMATION_SCHEMA.COLUMNS view.
Changing the Locking Scheme on a Table
by Navin Varma
Using the right type of locking on tables is very important to ensure application scalability.
Testing Compatibility Between SQL Server Versions
by Srinath MS
When migrating SQL code (stored procedures, triggers, etc.) to newer versions, it's not uncommon to have to rewrite your entire back-end code. However, a simpler solution is to check the exisiting code's compatibility with the newer versions.
Execute a SQL Statement with Variable Parameters
by Leonard Anghel
When you have to execute the same SQL statement (in general an UPDATE) for different values you can use the PreparedStatement.
Convert a java.util.Date Object to a java.sql.Date Object
by Leonard Anghel
The code in this tip demonstrates how to convert a java.util.Date object to a java.sql.Date object.
The #flastmod and #fsize Server-side Includes
by Srinath MS
The #flastmod and #fsize server-side includes provide important information on web pages hosted by classic ASP web sites.
Using ANYDATA in Oracle 9i
by Shraddha Pandya
First introduced in Oracle 9i, ANYDATA is a "self-describing data instance type" which means it not only holds the value, but it also holds its own data type within each instance of it.
When to use ORDER in Sequences in PL/SQL
by Shraddha Pandya
You may need to use ORDER to force sequence numbers to be output in the order of request when you're using them for timestamping.
Does Your RDBMS Support Savepoints?
by Leonard Anghel
Before using savepoints in your application, you need to be sure that your RDBMS supports this facility.
Quick Script Monitors Application-generated SQL
by Jason Bramsden
This script was written to monitor a program whose process life was only a few seconds. It runs forever and only outputs that SQL which is generated by the program as it's running.
Creating Oracle Table and Column Names that Start with an Underscore
by Amit Jain
The SQL syntax to create these tables is similar to that of creating any other table—with a slight difference.
Predicate Pushing
by Shraddha Pandya
Oracle supports the pushing of predicates into a given view.
Workaround for the SQL DISTINCT Clause
by Srinath MS
The SQL DISTINCT clause isn't case sensitive, which means that your query might end up pulling records with different cases.
Returning a Random set of Records
by Parthasarathy Mandayam
Find out how to use the NEWID() function to return a random set of records.
Remove MS SQL Server Completely
by Larry Sawchuk
Microsoft has several different versions of SQL and occasionally an install fails or an upgrade fails and normal uninstallation is impossible.
SQL Reporting Service: Using the rc:TargetLink Parameter for Drilldown Reports
by Jayadev D
Find out how to prevent SQL Server Reporting Services drilldown actions from opening in a new window.
Using the ElementPath Capability in SQL Reporting Service 2005
by Jayadev D
Using the ElementPath tag increases your risk of losing Fields when the data source is refreshed. Find out how to workaround this quirk.
How to Use Oracle Java XQuery API
by Leonard Anghel
This code illustrates the main steps involved in using the Oracle Java XQuery API (OJXQI).
Graphical Tools for MSDE
by John Joseph
MSDE's small-footprint SQL Server compatible database has now been retooled as SQL Server— and it does not include graphical tools.
41-60 of 2259     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date