Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact-SQL Programming and Query Writing Training Videos
Transact SQL Videos in Series Home  Subscriber Videos  

How to Decide Between Using a View, Function, or Stored Procedure (Video Series)

Video Image Video Category: Misc Stuff That Just Doesn't Fit Anywhere Else

Skill Level: 300 (Intermediate)

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
With so many types of objects in SQL Server, many people just getting started in SQL development get confused when to use which type of object. This short series (two parts) tries to help you understand the goals and limitations of each type of object (such as 'You can't use a stored procedure in a SELECT statement') and tries to make life easier for you.

Videos in this Series:


Miscellaneous Bits & Pieces:
Book You Should Probably Own: Kalen Delaney's "Inside SQL Server 2005"
Want to see what's going on in your log? Run DBCC log (<insert your database name here >) WITH TABLERESULTS
You can disable the "sa" account by setting your SQL Server security mode to Windows Authentication Only. You will still have an "sa" account but it will not be able to log in to your SQL Server

Other Websites We Offer
LearnSharePoint.com
Don't Forget!
100% Money Back Guarantee
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
1/8/2009 3:00:04 PM