| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Topic - Function in Queries

Page history last edited by Dr. Ron Eaglin 10 years, 1 month ago

Topic - Function in Queries

 

Week 4 is just an extension of what you have learned in Week 3. Function are very similar to stored procedures except that they return something. There are other limitations to functions (which you should review in the required reading). Stored functions are still useful in how they can be used in queries to simplify the SELECT statement.

 

Reading

 

Required - Documentation for Stored Function - http://msdn.microsoft.com/en-us/library/ms186755.aspx 

Required - User Discussion at Stack Overflow - http://stackoverflow.com/questions/178128/functions-vs-stored-procedures 

 

Optional - Documentation of using Stored Functions - http://www.sqlteam.com/article/user-defined-functions 

 

Lectures

 

Lecture - Getting Started with Stored Functions in SQL Server

Assignments

 

COP4709 Spring 2013 Assignments - Week 4 assignment.

 

Comments (0)

You don't have permission to comment on this page.