本文提供了一个SQL脚本示例，展示了如何使用SQL进行收益率更新操作及从通知历史中选择记录的方法。涉及的操作包括更新指定证券的收益率及按条件查询通知记录。
exec TimeSeries.dbo.updSECYield '0P00002Y5N','2011-01-31',3.08
select top 10 * from SupportData..NotificationHistory
where Id='429352'
--and LastUpdate > cast('2010-09-09 01:00:00' as datetime)
--and LastUpdate < cast('2010-09-09 05:00:00' as datetime)
order by LastUpdate desc
select top 10 * from SupportData..NotificationHistory
where Id='429352'
--and LastUpdate > cast('2010-09-09 01:00:00' as datetime)
--and LastUpdate < cast('2010-09-09 05:00:00' as datetime)
order by LastUpdate desc
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
