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 2254     Previous     Next
Simplify Classic ASP Debugging in VS 2005
by Srinath MS
Like its predessor, VS 2005 does not allow you to debug classic ASP pages by default. Instead, you have to do it manually.
Explore the Statements and Parameters Passed to SQL Server
by Cindy Rodriguez
Find out exactly what statements and parameters are passed to SQL Server.
Execute a Block of Text in SQL Server Management Studio
by Cindy Rodriguez
In SQL Server Management Studio, you can use the Alt key in your keyboard to select blocks of text to execute.
Create XML from an Array
by Cindy Rodriguez
Passing arrays as arguments to stored procedures is not currently possible in SQL Server, but you can use XML to accomplish this.
How To Debug Classic ASP Pages in VS 2005
by Srinath MS
VS 2005, like its predessor, does not allow debugging for classic ASP pages, by default. This forces you to attach the ASP worker process (w3wp.exe).
Executing Marked Text in SQL Server Management Studio
by Cindy Rodriguez
In SQL Server Management Studio, you can use the Alt key in your keyboard to select blocks of text to execute.
Quickly Determine Which Tables Need Indexes in SQL Server
by Srinath MS
A quick way to determine which tables need indexes is to use the SQL Server Profiler Create Trace Wizard with "Identify Scans of Large Tables."
Debugging SQL Server Stored Procedures Through Visual Studio.NET
by Srinath MS
Learn how to use Visual Studio.NET to debug SQL Server stored procedures.
Use UNION ALL Instead of UNION
by Srinath MS
To improve query speed, use the UNION ALL statement.
Calculate the Last Day of the Month for Any Given Date
by Raja Krishna
The code in this tip calculates the last day of the month for any given date.
Read an Image from a Database Using the getBinaryStream Method
by Leonard Anghel
This following code shows you how to extract an image from a database using the getBinaryStream method.
Creating Tables in the Default Tablespace
by MS Sridhar
Most users typically create tables in the default tablespace. Most of them are not familiar with the actual tablespaces concept and are not aware that this is responsible for the issues they encounter when large data is pumped into said tables.
Using the GRANT Command
by Alexander Ocher
The SQL GRANT command is used to grant access privileges to database objects and role authorizations.
Using MySQL's LIMIT Command to Control Returned Rows
by Srinath MS
Use the script shown in this tip to select a particular number of rows after a certain row in MySQL.
Determine the Version and Build Information for Microsoft SQL Server
by Alexander Ocher
Use the query shown in this tip to determine the version and build information for Microsoft SQL Server.
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.
21-40 of 2254     Previous     Next
Sitemap