Execute the following Microsoft SQL Server Transact-SQL (T-SQL) script in Management Studio (SSMS) Query Editor to find the partition for StoreID 512 assuming that the Store table is partitioned:

USE AdventureWorks;

SELECT Partition=$Partition.fnStorePartition (512) ;