发帖时的笔误。贴出我实际的查询语句吧:(1)select * from gea..useridentity where Verifykey like '00001C4A_4FBC_4CDE_AFA0_9C80460B7F97' //ok (2)select * from gea..useridentity where UserName like '00001C4A_4FBC_4CDE_AFA0_9C80460B7F97' //not work运行sp_lock的结果为: 51 7 0 0 DB S GRANT 53 10 0 0 DB S GRANT 54 4 0 0 DB S GRANT 57 7 0 0 DB S GRANT 58 7 0 0 DB S GRANT 60 7 0 0 DB S GRANT 61 7 0 0 DB S GRANT 62 1 85575343 0 TAB IS GRANT 63 7 0 0 DB S GRANT 68 9 0 0 DB S GRANT 69 9 0 0 DB S GRANT 70 9 0 0 DB S GRANT 71 9 0 0 DB S GRANT
汗一下自己的不专业:spid dbid ObjId IndId Type Resource Mode Status 51 7 0 0 DB S GRANT 53 10 0 0 DB S GRANT 54 4 0 0 DB S GRANT 57 7 0 0 DB S GRANT 58 7 0 0 DB S GRANT 60 7 0 0 DB S GRANT 61 7 0 0 DB S GRANT 62 1 85575343 0 TAB IS GRANT 63 7 0 0 DB S GRANT 68 9 0 0 DB S GRANT 69 9 0 0 DB S GRANT 70 9 0 0 DB S GRANT 71 9 0 0 DB S GRANT
lz你写的两个==吗
(2)select * from gea..useridentity where UserName like '00001C4A_4FBC_4CDE_AFA0_9C80460B7F97' //not work运行sp_lock的结果为:
51 7 0 0 DB S GRANT
53 10 0 0 DB S GRANT
54 4 0 0 DB S GRANT
57 7 0 0 DB S GRANT
58 7 0 0 DB S GRANT
60 7 0 0 DB S GRANT
61 7 0 0 DB S GRANT
62 1 85575343 0 TAB IS GRANT
63 7 0 0 DB S GRANT
68 9 0 0 DB S GRANT
69 9 0 0 DB S GRANT
70 9 0 0 DB S GRANT
71 9 0 0 DB S GRANT
51 7 0 0 DB S GRANT
53 10 0 0 DB S GRANT
54 4 0 0 DB S GRANT
57 7 0 0 DB S GRANT
58 7 0 0 DB S GRANT
60 7 0 0 DB S GRANT
61 7 0 0 DB S GRANT
62 1 85575343 0 TAB IS GRANT
63 7 0 0 DB S GRANT
68 9 0 0 DB S GRANT
69 9 0 0 DB S GRANT
70 9 0 0 DB S GRANT
71 9 0 0 DB S GRANT