大虾！快帮我看一下这一游标语句哪里错了，什么执行不了！！！快帮帮忙。谢谢了！

[lzh19861001]

declare @fempid varchar(20),@fempno varchar(6),@fname varchar(10),@fbirthday smalldatetime()
declare lzh cursor for select fempid,fempno,fname,fbirthday from t_emp where year(fbirthday)='1978'
open lzh
fetch next from lzh into @fempid,@fempno,@fname,@fbirthday
while @@fetch_status=0
begin
insert into t_emp2 values (@fempid,@fempno,@fname,@fbirthday)
fetch next from lzh into @fempid,@fempno,@fname,@fbirthday
end
close lzh
deallocate lzh

[xyxfly]

try:
insert into t_emp2 values (@fempid,@fempno,@fname,convert(varchar(10),@fbirthday,120))

另外．报什么错呢？

[liangpei2008]

--这样试一下
declare @fempid varchar(20),@fempno varchar(6),@fname varchar(10),@fbirthday smalldatetime

declare lzh cursor
for select fempid,fempno,fname,fbirthday from t_emp where year(fbirthday)='1978'
open lzh
fetch next from lzh into @fempid,@fempno,@fname,@fbirthday
while @@fetch_status=0
begin
insert into t_emp2 values (@fempid,@fempno,@fname,@fbirthday)
fetch next from lzh into @fempid,@fempno,@fname,@fbirthday
end
close lzh
deallocate lzh

[pao1uo]

declare @fempid varchar(20),@fempno varchar(6),@fname varchar(10),@fbirthday smalldatetime()
-->
declare @fempid varchar(20),@fempno varchar(6),@fname varchar(10),@fbirthday smalldatetime

再检查下数据类型是不是能对上，特别是fempid字段是不是varchar(20)，字符串类型的长度是否够

贴出错误信息