SELECT SUM(EmployeeID) FROM Orders

SELECT * FROM Orders ORDER BY OrderDate desc

ALTER TABLE Orders add column col int

SQLSERVER服务器中，给定表 table1 中有两个字段 ID、LastUpdateDate，ID表示更新的事务号，
LastUpdateDate表示更新时的服务器时间，请使用一句SQL语句获得{zh1}更新的事务号
答：Select ID FROM table1 Where LastUpdateDate = (Select MAX(LastUpdateDate) FROM table1)

        SELECT  A.*,CASE B.Approve WHEN '0' THEN '未处理' WHEN '1' THEN '已通过' WHEN '-1' THEN '未通过' END AS App
        ,CASE B.Freeze WHEN '1' THEN '冻结' WHEN '2' THEN '解冻' end as Free
        FROM Agent_ExpandApply A,PromotionUser_AgentUsers B
        WHERE ExpandID IN ( SELECT promotionUsersID FROM PromotionUser_AgentUsers WHERE AgentUsersID=14)
              and ExpandApplyID in
                          (SELECT     ExpandApplyID
FROM         Agent_ExpandApply AS t
WHERE     ExpandApplyID =
                          (SELECT     MAX(ExpandApplyID)
                            FROM          Agent_ExpandApply
                            WHERE      ExpandID = t.ExpandID)) AND
                            B.PromotionUsersID=A.ExpandID  order by ExpandID DESC

create TABLE [dbo].[Tree]
([ID] [int] IDENTITY (1, 1) NOT NULL,
[PID] [int] NULL ,
[Name][varchar] (10) COLLATE Chinese_PRC_CI_AS NULL) ON [PRIMARY]
Insert Tree(PID, Name) values(null, '公司')
Insert Tree(PID, Name) values(3, 'IT')
Insert Tree(PID, Name) values(1, 'Fin')
Insert Tree(PID, Name) values(5, 'XZ')
Insert Tree(PID, Name) values(1, 'HR')

alter function fGetTreeTable(@ID int=null)
returns @Tab table(ID int,PID int,Name varchar(10),lev int)
as
begin
declare @lev int
set @lev=0
while @lev=0 or @@rowcount>0
begin
set @Lev=@Lev+1
insert @Tab(ID,PID,Name,Lev)
select ID,PID,Name,@Lev from Tree
where (@Lev=1 and ((PID=@ID)or(@ID is null and PID is null)))or
PID in (select ID from @Tab  where Lev=@Lev-1)
order by ID
end
return
end
go
 select * from  fGetTreeTable(null)

-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:      <AuthorName>
-- Create date: <Create Date>
-- Description: <Description>
-- Modify [n]:  < Modifier,Date,Description >
-- =============================================

-- =============================================
-- Author:  <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- Modify [1]:  jack, 2010-01-31, 简化逻辑判断流程
-- Modify [2]:  david, 2010-02-20, 更新条件判断
-- =============================================
CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName>
 -- Add the parameters for the stored procedure here
 <@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>,
 <@Param2, sysname, @p2> <Datatype_For_Param2, , int> = <Default_Value_For_Param2, , 0>
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here
 SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>
END
GO

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[存储过程模板]
--SQL Server Management Studio Express Edition 下载地址 http://download.microsoft.com/download/1/1/0/110d908f-c445-4523-b939-220c7d135f3d/SQLServer2005_SSMSEE.msi
    /*
    参数声明
    @1 binary
    @2 bit
    @3 char
    @4 datetime
    @5 decimal
    @6 float
    @7 image
    @8 int
    @9 money
    @10 nchar(4000)
    @12 numeric
    @13 nvarchar(4000)
    @14 real
    @15 smalldatetime
    @16 smallint
    @17 smallmoney
    @18 timestamp
    @19 tinyint
    @20 varbinary
    @21 varchar(8000)
    */
AS
BEGIN
    /*禁止消息输出*/
    Set NOCOUNT ON
    /*变量声明*/
    Declare @错误号 int,
            @错误信息 varchar(8000),
            @影响行数 int,
            @临时ID int,
            @事务已启动 bit,
            @当前时间 datetime
    Set @当前时间=getdate()
    Set @事务已启动=0

    /*临时数据产生中*/

    Set @事务已启动=1
    /*设置事务的隔绝级别：其他的进程只读*/
    Set Transaction Isolation level repeatable Read
    /*开始事务*/
    BEGIN Tran

    /*内容开始*/

    --/*
    游标的使用
    Declare @游标变量1 varchar(20),@游标变量2 varchar(20)--.....
    --声明游标
    /*
    LOCAL：当前作用域有效
    FORWARD_ONLY：指定游标只能从{dy}行滚动到{zh1}一行。FETCH NEXT 是{wy}受支持的提取选项
    READ_ONLY：禁止通过该游标进行更新
    TYPE_WARNING：强制游标警告
    游标类型：STATIC 静态游标、DYNAMIC动态游标
    */
    Declare 当前游标 cursor LOCAL FORWARD_ONLY READ_ONLY TYPE_WARNING STATIC--DYNAMIC
        for
        Select 字段1,字段2--...
        From 表名 --where 条件1 and 条件2....
    --打开游标
    Open 当前游标
    --向游标附值
    FETCH NEXT From 当前游标 into @游标变量1,@游标变量2--.....
    --循环游标
    WHILE @@FETCH_STATUS = 0
        BEGIN
-------------------游标内部_开始-----------------------
            --执行内容
            --游标的使用技巧_开始====================================

            --定位到指定位置56488的记录
            fetch absolute 56488 from 当前游标 into @游标变量1,@游标变量2--.....
            --定位到当前记录相对位置前88记录
            fetch relative -88 from 当前游标 into @游标变量1,@游标变量2--.....
            --定位到当前记录前一条
            fetch prior from 当前游标 into @游标变量1,@游标变量2--.....
            --定位到当前记录后一条
            fetch next from 当前游标 into @游标变量1,@游标变量2--.....
            --定位到首记录
            fetch first from 当前游标 into @游标变量1,@游标变量2--.....
            --定位到尾记录
            fetch last from 当前游标 into @游标变量1,@游标变量2--.....

            --游标的使用技巧_结束====================================

-------------------游标内部_结束-----------------------
            FETCH NEXT From 当前游标 into @游标变量1,@游标变量2--.....
        END
    --关闭游标
    CLOSE 当前游标
    --删除游标
    DEALLOCATE 当前游标
    --*/

    /*判断模块*/
    Select @影响行数=@@rowcount,@临时ID=SCOPE_IDENTITY(),@错误号=@@error
    if @错误号>0
        BEGIN
            Select @错误号=50001,@错误信息=''
            Goto ErrCl
        end
    /*提交事务*/
    COMMIT TRANSACTION

    /*如有结果记录集返回*/
    Set NOCOUNT OFF
    /*返回的SQL查询语句*/
    Set NOCOUNT ON

    /*返回*/
    Return
ErrCL:
    /*如果事务已经启动，则回滚事务*/
    if @事务已启动=1 rollback transaction
    /*触发SQL自定义错误*/
    Raiserror @错误号 @错误信息
    /*返回*/
    Return
  
END