LastNext321Page 1 of 3Record 1 to 10 of 29

Tutorial Entries

Favourite
VOTE 0

SQL Tutorial Lesson 29: Creating User Defined Functions

Tutorial » By SQL Tutor On Aug 06, 2012 3:46:23 AM ,

As we've seen in the previous lesson, functions are incredible useful in SQL. Now we're going to learn how we can build our own functions that work just like the system ones. This can get a little complex, but it's well worth understanding.

Categories : SQL | Tags : User Defined Functions
Favourite
VOTE 0

SQL Tutorial Lesson 28: System Functions

Tutorial » By SQL Tutor On Aug 05, 2012 11:00:22 PM ,

SQL Server stores some special values in a function. A function is kind of like a stored procedure that runs in place and returns data that you need before processing the rest of the statement. You might see them in place of columns, in a where clause or anywhere else where you might see a variable or a literal value.

Categories : SQL | Tags : System Functions
Favourite
VOTE 0

SQL Tutorial Lesson 27: System Variables and Error Handling

Tutorial » By SQL Tutor On Aug 04, 2012 2:55:59 AM ,

Errors! Every programmer hates them but they are a fact of life. Up until now we've treated errors like something that just shouldn't happen. The truth is, SQL is a pretty solid language that doesn't have near as many error-causing events as other languages. This is thanks to how explicit you have to be with everything you do in SQL. It cuts down on errors.

Categories : SQL | Tags : System Variables, Error Handling
Favourite
VOTE 0

In the last lesson we learned how to control our SQL transactions. However, we really need to know how to fit this into a stored procedure to take full advantage of it. We’re going to pick up where we left off in the last lesson and add transactions, commits and rollbacks to our existing TransferMoneyToSavings stored procedure.

Categories : SQL | Tags : stored procedure, Transactions
Favourite
VOTE 0

SQL Tutorial Lesson 25: Transactions

Tutorial » By SQL Tutor On Aug 01, 2012 12:36:25 AM ,

You might have been asking yourself, "Isn't there a way to hit Undo in SQL Server?" It's a good and valid question. It's very easy to screw things up in a computer program, so why isn't there an undo feature to SQL server?

Categories : SQL | Tags : Transactions
Favourite
VOTE 0

SQL Tutorial Lesson 24: System Tables

Tutorial » By SQL Tutor On Jul 29, 2012 8:45:01 PM ,

One of the most curious things about SQL server is that it keeps its own system data in the same kind of database format and schema that you as the end user utilizes. The ability to look into the system’s database is very useful to developers. Being able to programmatically examine your things like a list of databases existing on the server or even the individual columns within serves lots of useful purposes.

Categories : SQL | Tags : System Tables
Favourite
VOTE 0

SQL Tutorial Lesson 23: System Commands

Tutorial » By SQL Tutor On Jul 27, 2012 7:52:18 AM ,

SQL Server is a powerful system. There is a lot going on under the hood that we can't see and don't know about. Today, we're going to look at some of the commands that we can use to take a look at what's going on outside our individual SQL session.

Categories : SQL | Tags : System Commands
Favourite
VOTE 0

SQL Tutorial Lesson 22: In-Line Decision Making

Tutorial » By SQL Tutor On Jul 26, 2012 9:29:34 AM ,

In a previous lesson we learned how to use the IF and THEN statements to direct the flow of logic in our application. However, sometimes the change in logic might only have to do with a column or a variable. Additionally, we sometimes need to make a decision based on the contents of a column on each row. Consider the following example.

Categories : SQL | Tags : Decision Making, CASE WHEN
Favourite
VOTE 0

SQL Tutorial Lesson 21: Formatting Text and Numbers

Tutorial » By SQL Tutor On Jul 22, 2012 11:34:36 PM ,

In this lesson, you will learn how to format the text and numbers.

Categories : SQL | Tags : t-sql, Format, SQL Basic
Favourite
VOTE 0

SQL Tutorial Lesson 20: Converting and Concatenating Values

Tutorial » By SQL Tutor On Jul 12, 2012 7:56:13 PM ,

In our last lesson, we developed a stored procedure that does some pretty cool things. It combines a lot of concepts we've learned thus far and even gives the user some feedback about what's happening. However, there are still some things we could do to make it work a little better.

Categories : SQL | Tags : t-sql, SQL Basic
LastNext321Page 1 of 3Record 1 to 10 of 29
Contributors
Categories