@WattingEmail int OUTPUT
AS
BEGIN SET NOCOUNT OFF;
DECLARE @count int
SELECT @count = COUNT(a.emailID)
FROM MailInfoDB.dbo.WaitingEmailLists a
where a.sentTime >= CONVERT(VARCHAR(10),GetDate(),120)
AND a.sentTime < CONVERT(VARCHAR(10),DATEADD(DAY,1,GetDate()),120)
SET @WattingEmail =@count
IF @count=0
BEGIN
return
END
SELECT a.emailID ,a.sentTime,a.subject,a.toDisplayName,a.body
FROM MailInfoDB.dbo.WaitingEmailLists a
where a.sentTime >= CONVERT(VARCHAR(10),GetDate(),120)
AND a.sentTime < CONVERT(VARCHAR(10),DATEADD(DAY,1,GetDate()),120)
SELECT ea.emailID ,ea.toAddress
FROM MailInfoDB.dbo.EmailAddressLists ea
WHERE ea.emailID in (SELECT we.emailID FROM MailInfoDB.dbo.WaitingEmailLists we where DateDiff(DD,sentTime,GetDate())=0) SELECT ss.host ,ss.mailPassword,ss.mailUserName
FROM MailInfoDB.dbo.SmtpServers ss
以上是存储过程的代码如果第一个记录集的有0条记录,就直接返回了
如果没有 返回所有的记录集,和输出的参数,请问 有什么办法都得到呢
AS
BEGIN SET NOCOUNT OFF;
DECLARE @count int
SELECT @count = COUNT(a.emailID)
FROM MailInfoDB.dbo.WaitingEmailLists a
where a.sentTime >= CONVERT(VARCHAR(10),GetDate(),120)
AND a.sentTime < CONVERT(VARCHAR(10),DATEADD(DAY,1,GetDate()),120)
SET @WattingEmail =@count
IF @count=0
BEGIN
return
END
SELECT a.emailID ,a.sentTime,a.subject,a.toDisplayName,a.body
FROM MailInfoDB.dbo.WaitingEmailLists a
where a.sentTime >= CONVERT(VARCHAR(10),GetDate(),120)
AND a.sentTime < CONVERT(VARCHAR(10),DATEADD(DAY,1,GetDate()),120)
SELECT ea.emailID ,ea.toAddress
FROM MailInfoDB.dbo.EmailAddressLists ea
WHERE ea.emailID in (SELECT we.emailID FROM MailInfoDB.dbo.WaitingEmailLists we where DateDiff(DD,sentTime,GetDate())=0) SELECT ss.host ,ss.mailPassword,ss.mailUserName
FROM MailInfoDB.dbo.SmtpServers ss
以上是存储过程的代码如果第一个记录集的有0条记录,就直接返回了
如果没有 返回所有的记录集,和输出的参数,请问 有什么办法都得到呢
解决方案 »
- 问题还是解决不了,sleep会阻塞别的委托,急。。。
- C#查找带关键字的行的问题
- C# 把DataGridView中的信息导出到EXcel
- 谢谢大侠再帮我看下!ASP的代码问题!
- 为何我将按钮改名后,单击事件中的按钮名还是原来的呀?
- 关于Vs2008的单元测试的问题
- WebService内存占用的问题及StringBuilder的使用问题
- 求一个遍历算法的替代方案
- ADO.NET问题,如何用SqlDataAdapter填充两张表到DataSet?
- string数据类型如何转换为ushort or short类型
- wpf GroupBox 位置控制
- Wcf 以前软件 现在更新一下服务 自定义工具错误
reader.NextResult();//读下个记录集