存储过程语法错误

[hndllx]

CREATE PROCEDURE [dbo].[sp_Contractmature_remind] AS

Declare @Email varchar(50)
Declare @Contact varchar(10)
Declare @ContractTitle varchar(100)
Declare @EmailTitle varchar(1000)

Declare My_cursor1 CURSOR FOR
Select Contact,Email,ContractTitle
from ContractInfo
Where getdate() between Reminddate and Autoneeddate
Open My_cursor1
While @@fetch_status=0
Begin
Fetch next from My_cursor1 into @Contact,
@Email,@ContractTitle
Select @EmailTitle=@Contact + ‘：
您签定的合同（‘ +
@ContractTitle + ‘）快要到期了，请续约
‘ from ContractInfo

Execute master.dbo.xp_sendmail
@recipients =@ Email,
@ subject =@ContractTitle, @message =
’请输入你的内容’
End
Close My_cursor1
Deallocate MY_Cursor1


为什么老提示第17行：'''附近有语法错误，必须声明变量'@'
那错了？

[dlkfth]

CREATE PROCEDURE [dbo].[sp_Contractmature_remind] AS

Declare @Email varchar(50)
Declare @Contact varchar(10)
Declare @ContractTitle varchar(100)
Declare @EmailTitle varchar(1000)

Declare My_cursor1 CURSOR FOR
Select Contact,Email,ContractTitle
from ContractInfo
Where getdate() between Reminddate and Autoneeddate
Open My_cursor1
While @@fetch_status=0
Begin
Fetch next from My_cursor1 into @Contact,
@Email,@ContractTitle
Select @EmailTitle=@Contact + '：
您签定的合同（' +
@ContractTitle + '）快要到期了，请续约
' from ContractInfo

Execute master.dbo.xp_sendmail
@recipients =@Email,
@subject =@ContractTitle, @message =
'请输入你的内容'
End
Close My_cursor1
Deallocate MY_Cursor1

两个问题 '不能用‘ , @email 不能用 @ email

[txlicenhe]

@Email
@subject