Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

Search the Tips
Tip Bank > Database Development

Database Development - Page 4

Active Server Pages
Data Access
Database Administration
Database Apis
Database Tuning
Relational Databases
  PL/SQL   Transact-sql
Sql Server
Visual Foxpro
61-80 of 2269     Previous     Next
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.
How to Backup an SQL Server Database in a Shared Network Location
by Jaya Nehru Kumar
This workaround allows you to back up shared network locations in the SQL database.
Date Formats for the DATE Data Type
by Srinath MS
SQL Server offers two date formats for the DATE data type.
Using the Logger to Trace JDBC Driver Managers and Drivers
by Mahendar Aleti
Using java.util.Logger as your logging/tracing tool allows you to take advantage of the Logging framework.
Retrieving a Single Value from a Database
by Nathan Broslawsky
This PHP function pulls a single field from a single record in the database once the MySQL connection has already been established.
The Value of Data Archiving
by Navin Varma
This simple table design modification helps you avoid lots of misery in your production environment.
Batch Processing in Hibernate
by Leonard Anghel
Suppose you need to insert 200,000 records into a database in Hibernate. You'll need to adjust these settings.
Determine Whether a Table Has an Identity Column
by Jaya Nehru Kumar
A simple, single line of code helps you determine whether a table has an identity column.
Changing Column Names in Oracle
by MS Sridhar
Oracle does not have a mechanism by which you directly change column names. But this workaround is quick and efficient.
Fetching the Last Entered Records in Oracle
by MS Sridhar
Oracle provides an easy way of retrieving the last records entered in your database.
Speeding Up Table Creation Activity
by Girija Nanduri
Find out how to speead up the creation of tables by using the nologging keyword.
61-80 of 2269     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date