SQL Server转换字符串到日期

I have a problem with conversion string to date. The thing is, I create the table, and I got database with a plenty of records, and I should load it to my table. I searched any solution but I found only with SELECT or CONVERT but singular record. I have a problem with conversion string to date