Find grant permissions on user roles in sql server

select dp.NAME AS principal_name,

o.NAME AS [object_name],

p.permission_name

from sys.database_permissions p

left OUTER JOIN sys.all_objects o

on p.major_id = o.OBJECT_ID

inner JOIN sys.database_principals dp

on p.grantee_principal_id = dp.principal_id

where dp.NAME not in ('public' ) and o.NAME is not null

and o.NAME not like '%_view'

order by 1,2

MERGE in TSQL

MERGE [dbo].[LOBSupportedPropertyType] A

USING [dbo].[#LOBSupportedPropertyType] B

ON

(

A.[ID] = B.[ID] AND A.[LOBId] = B.[LOBId] AND A.[TypeId] = B.[TypeId]

)

WHEN MATCHED THEN

UPDATE

SET A.[PropertyTypeId] = B.[PropertyTypeId]

,A.[PropertyTypeName] = B.[PropertyTypeName]

,A.[DefaultPropertyValue] = B.[DefaultPropertyValue]

,A.[PropertyTypeDisplayName] = B.[PropertyTypeDisplayName]

,A.[Guid] = B.[Guid]

WHEN NOT MATCHED THEN

INSERT

(

[ID]

,[LOBID]

,[TypeId]

,[PropertyTypeId]

,[PropertyTypeName]

,[DefaultPropertyValue]

,[PropertyTypeDisplayName]

,[Guid]

)

VALUES

(

B.[ID]

,B.[LOBID]

,B.[TypeId]

,B.[PropertyTypeId]

,B.[PropertyTypeName]

,B.[DefaultPropertyValue]

,B.[PropertyTypeDisplayName]

,B.[Guid]

);