Build a well-structured T-SQL program that retrieves all the rows from a specified table where a particular column contains a specific value. Please make sure to use appropriate syntax and formatting for optimal readability, and ensure that your program is efficient and free of syntax errors.
This prompt doesn't seem malicious.