Advanced Topics
Here are the articles in this section:
Lesson 23. Selecting Unique Values
Lesson 24. Updating Data With A Join
Lesson 25. Data Types
Lesson 26. Casting Data Types
Lesson 27. Creating Tables
Lesson 28. Altering Tables
Lesson 29. Dropping Tables
Lesson 30. Variables
Lesson 31. Controlling Flow
Lesson 32. Looping
Lesson 33. Error Processing
Lesson 34. Temporary Tables
Lesson 35. Views
Lesson 36. Indexed Views
Lesson 37. User Defined Functions
Lesson 38. Stored Procedures
Lesson 39. BULK INSERT
Lesson 40. Loading Tables With MERGE
Lesson 41. Partitioning A Dataset
Lesson 42. Pivoting Data
Lesson 43. Dynamic SQL
Lesson 44. Cursors
Last modified 1yr ago