Generate a list of dates

select dp.NAME AS principal_name,

dp.type_desc AS principal_type_desc,

o.NAME AS object_name,

p.permission_name,

p.state_desc AS permission_state_desc

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


with mycte as

(

select cast('1900-01-01' as datetime) DateValue

union all

select DateValue + 1

from mycte

where DateValue + 1 < '2050-12-31'

)

select DateValue

from mycte

OPTION (MAXRECURSION 0)[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7667023/viewspace-1007428/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7667023/viewspace-1007428/