SELECT * FROM Not Executing
Your BEGIN TRANSACTION is holding a lock on the table. You have to either:


Commit it with COMMIT
Roll it back with ROLLBACK
Use an isolation level hint in your query, like add WITH (NOLOCK) after the MOVIES table name
Use a different default isolation level in your database, like Read Committed Snapshot Isolation, where writers don't block readers (although you won't see data that isn't committed yet)
Run the SELECT query from the same session as your transaction (if you're working in Management Studio, that means running the query in the same tab/window)