TutorialGrub.com SQL Basics tutorials. http://www.tutorialgrub.com Sometimes with outputted data, comes unwanted white space. The trim function is used for this in SQL. http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/-How-to-Use-the-Trim-Function_6737.html http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/-How-to-Use-the-Trim-Function_6737.html Sun, 08 May 2011 09:00:01 CDT How to use the ORDER BY keywords to return rows in a defined order. http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/SQL-ORDER-BY_3796.html http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/SQL-ORDER-BY_3796.html Sun, 01 May 2011 11:04:47 CDT How to use the UPDATE statement to update or change rows in a table. http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/SQL-UPDATE_3802.html http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/SQL-UPDATE_3802.html Sun, 01 May 2011 04:30:02 CDT This tutorial will show how to create a Self-Contained Scalar Subquery in SQL Server. Using the WHERE and SELECT clauses we are able to retrieve a sin http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/How-to-Create-a-SelfContained-Scalar-Subquery-in-SQL-Server_3452.html http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/How-to-Create-a-SelfContained-Scalar-Subquery-in-SQL-Server_3452.html Sat, 30 Apr 2011 10:00:02 CDT This term is used for achieving database efficiency. For a good explanation of what/why click here. This tutorial will show you some common types of t http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/Relational-Databases_3422.html http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/Relational-Databases_3422.html Sat, 30 Apr 2011 05:30:09 CDT This tutorial will show how to outer join tables using the Join keyword. We will show three instances of outer join: left, right, and full. http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/How-to-Outer-Join-Tables-in-SQL-Server_3416.html http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/How-to-Outer-Join-Tables-in-SQL-Server_3416.html Fri, 29 Apr 2011 22:15:37 CDT Tutorial mainly uses syntax constructions of SQL-92 standard. It will help you to master in wide and varied possibilities for formulating queries of a http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/SQL-Exercises_3026.html http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/SQL-Exercises_3026.html Thu, 28 Apr 2011 12:30:02 CDT How to create databases, tables, and indices. http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/SQL-CREATE_2583.html http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/SQL-CREATE_2583.html Wed, 27 Apr 2011 06:30:13 CDT How to use BETWEEN....AND to find data in a range. http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/SQL-BETWEEN_2587.html http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/SQL-BETWEEN_2587.html Tue, 26 Apr 2011 15:30:03 CDT How to select information from multiple tables. http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/SQL-Join_2589.html http://www.tutorialgrub.com/tutorials/SQL-Basics/Miscellaneous/SQL-Join_2589.html Tue, 26 Apr 2011 14:30:04 CDT