存储过程语法错误
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行:'''附近有语法错误,必须声明变量'@'
那错了?