Obtain database ID number

SELECT DB_ID(N'AdventureWorks2008R2') AS [Database ID]