dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips

SQL - Page 2

PL/SQL
  SQL
Transact-sql
21-40 of 719     Previous     Next
Setting a Default NULL Date in SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how easy it is to set a Default NULL Date in SQL.
Determine Which Providers Are Installed on Your Server
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to check which providers are installed on your server.
Understand Permissions Granted to a User in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to find the permissions available for a given user in MySQL.
SET ARITHABORT ON
by Hannes du Preez
Language: SQL, Expertise: Beginner - See why you should use SET ARITHABORT ON.
Import Excel Data into SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn about how to read from an Excel Spreadsheet via SQL.
Finding Collations
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn how to find collations in your tables.
Determine Which Version of SQL You Are Running
by Hannes du Preez
Language: SQL, Expertise: Beginner - Check out these two T-SQL methods that determine which version of SQL you are running.
Display the Contents of a Stored Procedure
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn more about a simple query to show the contents of your Trigger.
Replacing Strings in Your Output
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn how to replace strings in SQL.
Find Duplicates in Your Table
by Hannes du Preez
Language: SQL, Expertise: Beginner - Use a query similar to this one to find duplicates in your tables.
Handy Function to Test for Email Validity
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Use this nifty function to check the validity of an email address.
Bypassing the Row Values Updated or Deleted Error
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to bypass this SQL error with a simple query.
Enable SQL Server to Run Stored Procedures at Server Startup
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn the two-step process required to run stored procedures at startup.
How to Include All Values in a Date Range
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to include all values in a date range by using minus 1 second trick.
Access Previous Row Value and Next Row Value
by Hannes du Preez
Language: SQL, Level: Beginner: - Check out a quick way to access information from the previous row or next row from the current row.
Quick Tip for Removing Ambiguity in Database Queries
by Srinath M S
Language: SQL, Expertise: Intermediate - Learn why it's helpful to fully qualify database objects so that there is no place for ambiguity.
How to Check for a NULL Value and an Empty String
by Hannes du Preez
Language: SQL, Expertise: Beginner - This query checks for null values, as well as empty strings, then provides a suitable replacement on either occasion.
Easily Get the Inserted Identity in SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to easily get the inserted identity in SQL.
Statistics IO and Statistics Time
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Easily figure out the amount of time spent on a query and the reads and writes of the query in question.
Print All Table Column Definitions in an Entire Database
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to print all column definitions for all the tables in your database.
21-40 of 719     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date