/* Level 1 Assignments: */
Select [definition]
From [sys].[sql_modules]
Where Lower([definition]) Like '%convert%'

Select [definition]
From [sys].[sql_modules]
Where Lower([definition]) Like '%nolock%'

/* Level 2 Assignments: */
Select
    [sql_modules].[definition],
    [objects].name
From [sys].[sql_modules] AS [sql_modules]
Inner Join [sys].[objects] AS [objects]
    On [sql_modules].[object_id] = [objects].[object_id]
Where [objects].[type_desc]  = 'SQL_SCALAR_FUNCTION'

Select
    [schemas].[name] As [schema_name],
    [views].[name] as [view_name],
    [sql_modules].[definition]
From [sys].[views] as [views]
Inner Join [sys].[schemas] as [schemas]
    On [views].[schema_id] = [schemas].[schema_id]
Inner Join [sys].[sql_modules] AS [sql_modules]
    On [sql_modules].[object_id] = [views].[object_id]

/* Level 3 Assignment: */
Select Distinct [type]
    From [sys].[objects]
Except
Select Distinct [objects].[type]
    From [sys].[objects] as [objects]
Inner Join [sys].[sql_modules] as [sql_modules]
    On [objects].[object_id] = [sql_modules].[object_id]