在这段时间之内
datetime between '2009-8-20 0:00:00'and '2009-8-21 0:00:00'
如果查询到名字等于maodi就把性别换成男,否则就是原有的值。
select name,
case
when name = 'maodi' then '男'
end as sex from studen
CREATE PROCEDURE AddAdmin
--接受管理员参数
AS
BEGIN
--插入管理员信息
--@@identity表示你上一步做的操作返回的标识列
declare AdminID int
--得到学校ID
select AdminID = @@identity
--插入一条空信息的学校数据
declare DriveSchoolID int
--得到学校ID
select DriveSchoolID = @@identity
--两个ID都得到了
--往关系表插入一个关联信息
END
GO
分享到:
相关推荐
使用Between查询时间段.rar使用Between查询时间段.rar使用Between查询时间段.rar
该资源只是一个PPT,内容是AV1和HEVC在编码流程上的一些对比
(1)ASN.1 Complete.pdf (2)ASN.1 Communication between Heterogeneous Systems.pdf
NATBLASTER-Establishing TCP Connections Between Hosts Behind NATs.pdf
Interaction between JavaScript and CAR.ppt
Transformation between JSON and struct. (类似Java Gson,C语言实现.zip
toolbox of BVQX, This is the access between BV and matlab. It will help you to analysis data from BV in matlab more efficiently.
描述PB的并发控制机制,详细解释Row changed between retrieve and update错误出现的原因,以及处理方法。对学习PB有一定的帮助。
Apress.Social.Networking.Spaces.From.Facebook.to.Twitter.and.Everything.In.Between.Mar.2010.part1.rar
Apress.Social.Networking.Spaces.From.Facebook.to.Twitter.and.Everything.In.Between.Mar.2010.part2.rar
Code for this paper: http://bbs.pinggu.org/forum.php?mod=viewthread&tid=6214243&pid=49150963&page=1
Differences between C++ and C# 可以看看。
Safe interop between Rust and C++
Connection between WinCC and PLCSIMdoc,Connection between WinCC and PLCSIM
LINUX 程序间进程通信 此编码为操作系统原理实验内容
线程之间的通信 包括全局变量 事件 线程可以实现通信
Between区间查询.rarBetween区间查询.rar
A computer's architecture is its abstract model and is the programmer's view in terms of instructions, addressing modes and registers. A computer's organization expresses the realization of the ...
COMPUTE_YEARS_BETWEEN_DATES.doc
Message passing between iOS apps and extensions..zip,iOS应用程序和扩展之间的消息传递。