Sometimes we need to update data in one table based on the contents of one or more other tables. Discover how the UPDATE from SELECT variation of SQL Server’s UPDATE statement provides an easy way to achieve this.
Scripting all logins on a SQL Server instance can be helpful e.g. when setting up a test or development environment. Read on to see an example query for just this purpose.
Are you looking to get the complete list of implied permissions for a given permission? Read on to discover a query returning just that list, based on a recursive CTE against the sys.fn_builtin_permissions catalog function.