SET STATISTICS TIME ON

记录查询的相关数据

 

---

 

生成随机Guid

SELECT NewID()

---

按照某一列排序并生成序号

select    Row_Number() OVER (ORDER BY Name) [Index]    ,Name,ID    ,NewID() RandomCodefrom Users

Over后面的括号中就是排序的语句 可以写 Order By XXX 或 Order By OOO Desc

---

 --判断存储过程是否存在

IF EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_ID(N'[P_EF_ExpertInvalidStatistic]') AND

        OBJECTPROPERTY(ID, N'ISPROCEDURE') = 1)

    DROP PROCEDURE P_EF_EXPERTINVALIDSTATISTIC

GO

--判断表是否存在

IF EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_ID(N'[tb_Emp_InvalidExpert]') AND

        OBJECTPROPERTY(id, N'IsUserTable') = 1)

    DROP TABLE tb_Emp_InvalidExpert

GO