try like this..
select cast(SUBSTRING('11122014',1,2)+'/'+SUBSTRING('11122014',3,2)+'/'+SUBSTRING('11122014',5,4) as date)
Updated:
declare @val as varchar(max)
set @val='11122014101012'
select cast((SUBSTRING(@val,1,2)+'/'+SUBSTRING(@val,3,2)+'/'+
SUBSTRING(@val,5,4)+' '+SUBSTRING(@val,9,2)+':'++SUBSTRING(@val,11,2)+':'+SUBSTRING(@val,13,2)) as datetime)