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 4

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
61-80 of 2259     Previous     Next
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.
Retrieve the Month's First Day for a Date
by Amit Vij
This code shows you how to retrieve the month's first day for a date.
Fetching Even and Odd Records in Oracle
by MS Sridhar
This tip will help you understand how to apply the mod function and use it to obtain even and odd records from columns in Oracle.
Identify "Drop Out" Columns Used in Stored Procedure Definitions
by Jaya Nehru Kumar
Find out an incredibly easy way to identify dropped out columns used in stored procedure definitions.
Insert the Current Date/Time in a SQL Server, Excel Spreadsheet, or MSAccess
by Srinath MS
The following keyboard shortcuts are quick ways to insert the current date and time in an Excel spreadsheet, Access table, or SQL Server table.
Count the Number of Rows in Two Tables Using a Single Query
by Sanjay Agarwal
Learn three different ways to count the number of rows in two tables using a single query.
Display Table Information
by Neeraj Tyagi
See the code that allows you to display all your table's information.
The Purpose of the GO Statement
by Sachin Kainth
Although GO is not a T-SQL statement, it is often used in T-SQL code and unless you know what it is it can be a mystery. Find out its purpose in this tip.
Dealing with Wildcard Characters in Oracle
by MS Sridhar
The ESCAPE keyword comes handy when you have a character in your data which is same as a Wildcard character.
Retrieve All Columns from Each Table in Every Database
by Mohammad Khan
This stored procedure retrieves all the columns of each table in every database.
Retrieve Records from a Supplied SQL Statement
by Syed Mohamed
Learn how to retrieve records from a supplied SQL statement.
61-80 of 2259     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date