e_mail2.sql

感应IC卡电脑考勤、门禁、售饭一卡通管理系统是基于我公司开发生产的ESW型智能卡记录器所具有的对持卡人刷卡卡号、时间、次数进行读取贮存等功能

DROP PROCEDURE TS_E_Mail
GO
CREATE PROCEDURE TS_E_Mail AS
DECLARE @sEBookAdmin varchar(60)
SELECT @sEBookAdmin =MailEBookAdmin FROM S_SysSet WHERE ID =1

SELECT MailTo=CONVERT(varchar(60), E.G_Mail)
   ,sSubject =CONVERT(varchar(60), 'e瓜