摘要:
if exists(SELECT *FROM [DBPersonnel].[dbo].[TB証明書] where [社員番号]='001') update [DBPersonnel].[dbo].[TB証明書] set [身分証明書]='11' where [社員番号]='001'else INS... 阅读全文
摘要:
drop table x gocreate table x(id varchar(10))--insert into x values('A001')gowith a as (select ISNULL(max(id),'A0000') maxid from x) insert into x (i... 阅读全文
摘要:
内存: 4 Gos: windows 2003数据库: ms sql server 2008目的: 查询性能测试,比较两种查询的性能SQL查询效率 step by step-- setp 1.-- 建表create table t_userinfo(userid int identity(1,1) ... 阅读全文