e_mail2.sql

来自「感应IC卡电脑考勤、门禁、售饭一卡通管理系统是基于我公司开发生产的ESW型智能卡」· SQL 代码 · 共 8 行

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瓜