Right or Wrong, Dynamic SQL AND a Cursor

set nocount on
declare @Database        varchar(200) = '[<your database here>]'
declare @FileDirectory   varchar(200) = 'E:\Transfer\TransactionLogs\'
declare @DirCMD          varchar(8000) = 'dir /b /o:d ' + @FileDirectory + '<database_Name_here>_backup_*.trn'
declare @TransactionLogs table (ID       int primary key identity(1,1)
                               ,FileName varchar(500)
                               )
declare @TransactionLogFile     varchar(500)
declare @SQL                    varchar(max)
declare @CRLF                   char(2) = char(13) + char(10)
declare @FullyQualifiedFileName varchar(200)

insert into @TransactionLogs (FileName)
exec xp_cmdshell @DirCmd
delete from @TransactionLogs where FileName is null

declare TransLog_Cursor cursor for
select FileName
from @TransactionLogs
order by ID

open TransLog_Cursor
fetch next from TransLog_Cursor into @TransactionLogFile
while @@FETCH_STATUS = 0
begin
set @FullyQualifiedFileName = @FileDirectory + @TransactionLogFile
set @SQL  = 'RESTORE LOG '     + @Database                      + @CRLF
    set @SQL += 'FROM  DISK = N''' + @FullyQualifiedFileName + '''' + @CRLF 
    set @SQL += 'WITH  FILE = 1'                                    + @CRLF
    set @SQL += ',  NORECOVERY'                                     + @CRLF
    set @SQL += ',  NOUNLOAD'                                       + @CRLF
    set @SQL += ',  STATS = 10'                                     + @CRLF
print 'Restoring Transaction File: ' + @TransactionLogFile
exec (@SQL)
print '-- -- --'

fetch next from TransLog_Cursor into @TransactionLogFile
end
close TransLog_Cursor
deallocate TransLog_Cursor

set @SQL = 'restore database [Integration_Layer_20131007] with recovery'
exec (@SQL)