Extract data between two dates in sqlserver

declare @sqlStr varchar(4000)
declare @FromDate varchar(4000)
declare @ToDate varchar(4000)

set @sqlStr=''
SET @FromDate='03/31/2013'
SET @ToDate='07/31/2013'

set @sqlStr = 'select row_number() over (order by (select(1))) as SNo, TC.Name,convert(varchar(13),TC.DOB,103) as DOB
               from tbl_Emp as TC '          
 

For Dynamic date

set @sqlstr=@sqlStr+' where DOB between CONVERT(VARCHAR(15),'''+@FromDate+''',103) AND CONVERT(VARCHAR(15),'''+@ToDate+''',103)'
 
 exec(@sqlstr)



For static date

set @sqlstr=@sqlStr+' where DOB between CONVERT(VARCHAR(15),''03/31/2013'',103) AND CONVERT(VARCHAR(15),''07/31/2013'',103)'

 exec(@sqlstr)