Duration: 20:44 min
Summary: In this video, we will discuss some of the T-SQL functions that we need in our day-to-day development. In addition to selecting, deleting, updating, and inserting records into the database, we need to operate on the data. How about removing spaces from strings? Reversing text? And taking a slice from a string? That is what we will be doing today. We will learn these functions and see how they operate on data. I will also introduce you to SQL Server books online to look things up when you are not sure how a specific item works.
Technologies and Resources: T-SQL, AdventureWorks 2012, Substring, Reverse, Replicate, Replace.