I want to create a template in sharepoint 2013 and connected to an SQL server table, so it will populate with the info entered in a form.
The "proper" way to do this is with Business Connectivity Services (BCS). BCS can be a bit heavy handed if your needs are for a periodic one way sync of a single list.
Does it have to be real-time? The path of least resistance would be a scheduled SSIS package leveraging the SharePoint List Connector available here: http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652