我哥们昨天看错一张表,删了一万多条数据,那可是几百万的损失啊,所有的领导都他妈过去了,搞数据库还原,折腾到晚上1,2点钟,我哥们吓的腿都软了 当时
哎一个简单的语句测试半天真是郁闷 不过也算有收获,,,搞不动的时候还是去眺望远方,,或者眼保键操吧 顺便分享下,,,,小知识 declare @t table (c1 int,c2 varchar(2)) insert into @t select 7 as c1,7 as c2 union all select 8 as c1,8 as c2 union all select 9 as c1,9 as c2 union all select 10 as c1,10 as c2 union all select 11 as c1,11 as c2 union all select 12 as c1,12 as c2 union all select 13 as c1,13 as c2 select count(*) from @t where c1>7 --6 select count(*) from @t where c1>'7' --6 select count(*) from @t where c2>7 --6 select count(*) from @t where c2>'7' --2
11,848
社区成员
33,693
社区内容
加载中
试试用AI创作助手写篇文章吧