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

SQL

PL/SQL
  SQL
Transact-sql
1-20 of 612     Previous     Next
Getting All Stored Procedures Inside a Database
by Hannes du Preez
Language: SQL||Expertise: Intermediate
PIVOTing Data in SQL
by Hannes du Preez
Language: SQL||Expertise: Advanced
Putting a NULL Date Value Last
by Hannes du Preez
Language: SQL||Expertise: Beginner
Determine who and what Caused a Deadlock in one of your Database Objects
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Find out When the Last Full Backup was Taken
by Hannes du Preez
SQL query that displays the last time a full backup was taken, as well as the user who took the last backup.
Obtaining Actual & Estimated Execution Plans for SQL Queries
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Backup and Restore an SQL Database
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Work Around to Fix Datetime - Primary Key Violation Issue
by Jaya Nehru Kumar
Work around to fix datetime - primary key violation issue
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.
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.
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.
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.
1-20 of 612     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date