<p>What's the most appropriate type used to store the duration time information of a video in sql server?</p>

I would store it as an INT representing the number of seconds, but I suppose it all depends what you need to do with the information in your database (you wouldn't want to have to convert it to HH:MM:SS or something else in your DB)