http://www.sqlservercentral.com/blogs/sql_awesomesauce/2011/08/18/applied-sql_3A00_-sys.sql_5F00_modules/

Printed 2014/11/22 08:53PM

Applied SQL: sys.sql_modules

By Jen McCown, 2011/08/18

I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.

Prerequisites: basic T-SQL (including JOINs and LIKE), basic knowledge of catalog views

Reading: SQL Server Books Online sys.sql_modules article.

Level 1 Assignments: Using sys.sql_modules, write a query for each of the following:

Level 2 Assignment: Using sys.sql_modules, write a query for each of the following:

Level 3 Assignment:

Bonus points: Post your scripts (or a link to them) in the comments below, just to show off that you did it.

Happy learning,
Jen McCown
www.MidnightDBA.com/Jen


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.