Attach only mdf file - SQL Server

USE [master]

GO

EXEC sp_attach_single_file_db @dbname='Student',

@physname=N'C:\Shihafath\Student.mdf'

GO

thank you http://blog.sqlauthority.com/