这样写存储过程错在哪？

[linxi]

CREATE PROCEDURE sp_BackupData @dbname varchar(20), @t_name varchar(20),@date_name varchar(20),@start_date smalldatetime,@end_date smalldatetime
AS
DECLARE @sql1 varchar(400)
DECLARE @sql2 varchar(400)
set @sql1=('insert into'+ @dbname+'_bak..'+@t_name+' (select * from '+@dbname+'..'+@t_name+' where'+ @date_name +'between'+ @start_date + 'and' +@end_date+')')
exec (@sql1)
go

[caiyunxia]

CREATE PROCEDURE sp_BackupData @dbname varchar(20), @t_name varchar(20),@date_name varchar(20),@start_date smalldatetime,@end_date smalldatetime
AS
DECLARE @sql1 varchar(400)
DECLARE @sql2 varchar(400)
set @sql1=('insert into'+ @dbname+'_bak..'+@t_name+' (select * from '+@dbname+'..'+@t_name+' where'+ @date_name +'between'''+ @start_date + '''and''' +@end_date+''')')
exec (@sql1)

[caiyunxia]

set @sql1=('insert into '+ @dbname+'_bak..'+@t_name+' (select * from '+@dbname+'..'+@t_name+' where '+ @date_name +' between '''+
convert(char(20),@start_date,120) + ''' and ''' +convert(char(20),@end_date,120)+''')')

[caiyunxia]

'insert into'\' where'\'between'\'and' 前后需加空格
@end_date、@end_date应该转换为字符类型
并在其前后加‘’

[pengdali]

CREATE PROCEDURE sp_BackupData @dbname varchar(20), @t_name varchar(20),@date_name varchar(20),@start_date smalldatetime,@end_date smalldatetime
AS
DECLARE @sql1 varchar(4000)
DECLARE @sql2 varchar(4000)
set @sql1='insert '+ @dbname+'_bak..'+@t_name+' select * from '+@dbname+'..'+@t_name+' where '+ @date_name +' between '''+ CONVERT(varchar(10),@start_date,120) + ''' and ''' +CONVERT(varchar(10),@end_date,120)+''''
exec (@sql1)
go

[愉快的登山者]

set @sql1=('insert into'+ @dbname+'_bak..'+@t_name+' (select * from '+@dbname+'..'+@t_name+' where '+ @date_name +' between "'+ convert(varchar, @start_date, 120) + '" and "' +convert(varchar, @end_date, 120)+'")')