- 博客(7)
- 资源 (4)
- 收藏
- 关注
原创 处理表重复记录
--处理表重复记录(查询和删除)/******************************************************************************************************************************************************1、Num、Name相同的重复值记录,没有大小关系只保留一条2、N
2011-06-30 16:12:00 460
原创 主账号处理
drop table Acreate table A(id int identity(1,1) not null primary key,acc varchar(100),flag int default 0,iszhu char(1) default 0)insert A(acc)select 101 000550 8091 111union allselect 101 000550 80
2011-06-30 10:54:00 792
原创 CTE递归查询
查找ron的所有上级,mdrig表示上级的empidcreate table employees(empid int , mgrid int , name varchar(10))insert into employees values(1 , null , nancy)insert into employees values(2 , 1 , andrew)insert int
2011-06-24 13:47:00 2444
原创 sql server上班时间的计算
select datediff(minute,2011-06-10 8:30,2011-06-10 11:45)+ datediff(minute,2011-06-10 14:00,2011-06-10 17:30)declare @dt1 datetime,@dt2 datetimeset @dt1=2011-06-10 16:00set @dt2=2011-06-13 9
2011-06-16 16:31:00 2856
原创 Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state
用vs运行时正常,但是用sql server job运行时出现如下的错误,只要按图设置package属性即可
2011-06-14 13:54:00 3404
原创 the account is currently locked out. The system administrator can unlock it.
<br />今天碰到一个比较难得见到的问题,sqlserver 连接不上,具体信息为the account is currently locked out. The system administrator can unlock it.<br /> <br />原来是在sa的账户上设置了密码策略,取消如图的两个勾即可<br /> <br />
2011-06-02 17:58:00 3069 3
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人