Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* 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]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement