The query below can retrieve database id by supplying the database name
-- Show database id using system view
SELECT
database_id
FROM
sys.databases
WHERE
name
=
'<db_name>'
;
-- Show database id using function
SELECT
DB_ID(
'<db_name>'
);
Big thank you for sharing this post its very knowledgeable and very helpful i hope that you will continue to post these kinds of contents in future apart from that if anyone looking for e accounting institute in delhi so Contact Here-+91-9311002620 Or Visit Website- https://www.htsindia.com/Courses/Tally/e-accounting-training-course
ReplyDelete