惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

S
Schneier on Security
有赞技术团队
有赞技术团队
T
The Blog of Author Tim Ferriss
F
Fortinet All Blogs
D
DataBreaches.Net
F
Full Disclosure
腾讯CDC
博客园 - 【当耐特】
MyScale Blog
MyScale Blog
Stack Overflow Blog
Stack Overflow Blog
小众软件
小众软件
Hugging Face - Blog
Hugging Face - Blog
Last Week in AI
Last Week in AI
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
爱范儿
爱范儿
The GitHub Blog
The GitHub Blog
Engineering at Meta
Engineering at Meta
大猫的无限游戏
大猫的无限游戏
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
S
SegmentFault 最新的问题
The Register - Security
The Register - Security
WordPress大学
WordPress大学
博客园 - 聂微东
雷峰网
雷峰网
J
Java Code Geeks
Exploit-DB.com RSS Feed
Exploit-DB.com RSS Feed
P
Privacy International News Feed
酷 壳 – CoolShell
酷 壳 – CoolShell
A
Arctic Wolf
Scott Helme
Scott Helme
C
Cyber Attacks, Cyber Crime and Cyber Security
T
Tor Project blog
博客园 - 三生石上(FineUI控件)
Know Your Adversary
Know Your Adversary
AWS News Blog
AWS News Blog
G
Google Developers Blog
www.infosecurity-magazine.com
www.infosecurity-magazine.com
C
CERT Recently Published Vulnerability Notes
O
OpenAI News
Project Zero
Project Zero
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
Application and Cybersecurity Blog
Application and Cybersecurity Blog
云风的 BLOG
云风的 BLOG
N
News and Events Feed by Topic
MongoDB | Blog
MongoDB | Blog
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
Microsoft Security Blog
Microsoft Security Blog
Cisco Talos Blog
Cisco Talos Blog
P
Palo Alto Networks Blog
Schneier on Security
Schneier on Security

博客园 - Eagletian

小结 薪酬管理 小结 小结 小结 管理定律大全 www.shanzei.com ITSM网上资源导航 From:act.it.sohu.com 《IT服务管理:概念、理解与实施》 实战Delphi数据网格色彩特效 自制精美易用的DBGrid from: www.delphifans.com 谁有能让窗体自动适应显示器分辨率的控件? From: www.delphibbs.com Delphi分布式系统(MIDAS)中动态调用存储过程 From: www.ccw.com.cn Delphi - Stored procedures returning data (MSSQL, Firebird, Oracle) From: http://www.scip.be 图像数据的数据库应用程序 SQL Server存储图像数据的策略与方法 在delphi中获取SQL Server的错误信息初探 我对DELPHI写的几个基类型 From: www.donews.net Delphi 7.0常用函数速查手册 创建Photoshop式浮动窗口应用程序 From:csdn Delphi自定义消息应用一例 From:www.bvtc.com.cn
修改时间
Eagletian · 2005-06-23 · via 博客园 - Eagletian

declare @time varchar(8),@datetime datetime

declare cursor_time cursor for select right(datetime,8) from att_original where left(datetime,10) = '06 11 2003'
open cursor_time
fetch next from cursor_time into @time

declare cursor_user cursor for select * from att_original  where left(datetime,10) = '06 11 2003'
open cursor_user

fetch next from cursor_user

while @@fetch_status = 0
begin
  set @datetime = '2005-06-11 '+ '' + @time
  update att_original set datetime = @datetime where current of cursor_user

  fetch next from cursor_user
  fetch next from cursor_time into @time
end

close cursor_user
deallocate cursor_user

close cursor_time
deallocate cursor_time

select * from att_original