Login | Register   
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
Sql Server
Visual Foxpro
1-20 of 2254     Previous     Next
How to Read Environment Variables in SQL Server Using T-SQL
by Deepak Choudhari
The xp_cmdshell extended stored procedure in SQL Server enables you to read environment variables in T-SQL.
Use Comparison Operators in SQL to Remove/Return Columns with Null Values
by Srinath MS
When you use the comparison operators in SQL with the Where clause, you can remove the columns with null values.
Displaying the Row Number in a SELECT Query with SQL Server 2005
by Deepak Choudhari
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row.
Retrieving Table Size in SQL Server
by Deepak Choudhari
Use this handy tip to determine the size of your SQL Server tables, which can be very useful for estimating the size and growth of a database over time.
A Better Way to Retrieve the ID of the Last Inserted Record
by Martin Vitek
An update to a previous tip on retrieving the ID of the last inserted record, this version uses less code and avoids a search of the jobs table.
Choosing a Large-Text Data Type for SQL Server Table Columns
by Deepak Choudhari
SQL Server offers several different data types for storing large amounts of data in table columns. But which should you use?
Avoid Multiple Queries When Querying for Max and Min Values
by Cindy Rodriguez
Instead of making one query to get the Max and Min values for a column, and then making another query to get additional information about those rows, you can do it all in one query.
Discover Long-Running Queries
by Srinath MS
Let SQL Server tell you which queries take the longest to run.
Get a Table Description in Oracle's PL/SQL
by Aaron Mason
Using Oracle's PL/SQL, you can get complete table column descriptions using this command.
Determine Whether a Field Exists in an ADODB.Recordset
by Shawn Dorman
Unless you populated a recordset yourself, you may not know whether it contains a particular field.
Find All User-Defined Functions in a SQL Server Database
by Jaya Nehru
This query returns all the user-defined functions in the specified database.
Determine Which Session Is Blocking All Users in Oracle
by Srinath MS
You can find out which session is causing blocking problems using this SQL command.
Consuming .NET Web Services from Classic ASP with the Microsoft SOAP Toolkit
by Srinath MS
The Microsoft SOAP Toolkit makes it easy to use .NET web services from classic ASP.
How to Store Oracle 10g Log Files in XML
by Srinath MS
Oracle 10g supports several ways to store log files, including XML.
Writing a Parameterized SQL Query in EJB 3.0
by Leonard Anghel
Follow this DELETE statement example to write parameterized SQL queries in EJB 3.0.
Using the EXISTS Command in SQL
by Annem Jyothsna
Using EXISTS can improve the performance of your SQL queries.
Run a Partial Query in TOAD
by Chithra Vijayan
You can run any portion of a SQL command in TOAD, even if it's embedded in a larger query.
Write a Complex Query in Hibernate
by Leonard Anghel
This example shows how to use the findByExample method in Hibernate in conjunction with the SQL AND operator to find and log in a user given an email address and password.
Table Variables Are More Efficient than Temporary Tables In Some Cases
by Srinath MS
Using @TABLE rather than temporary tables improves performance for small tables that don't require indexes.
Rebuild All Table Indexes in a SQL Server Database with One Command
by Srinath MS
An undocumented stored procedure lets you refresh all the table indexes in a SQL Server database with a single command.
1-20 of 2254     Previous     Next
Sitemap