--访问excel文件 select * from openrowset('microsoft.jet.oledb.4.0','excel 5.0;hdr=no;imex=1;database=d:\test.xls',sheet1$)--访问临时表加with (nolock)select * from #t with (Nolock)
51 12 0 0 DB S GRANT 51 1 85575343 0 TAB IS GRANT 52 12 5575058 0 TAB IX GRANT 52 12 0 0 DB S GRANT 52 12 5575058 2 KEY (6d018b3519c6) X GRANT 52 12 5575058 2 KEY (dd0032934a1f) X GRANT 52 12 1141579105 1 KEY (2b00dc0888a9) X GRANT 52 12 1141579105 1 PAG 1:151 IX GRANT 52 12 1141579105 0 TAB IX GRANT 52 12 5575058 2 PAG 1:167 IX GRANT 52 12 5575058 1 PAG 1:189 IX GRANT 52 12 5575058 1 KEY (d8004334cc30) X GRANT 52 12 5575058 1 PAG 1:206 IX GRANT 54 12 0 0 DB S GRANT
select * from openrowset('microsoft.jet.oledb.4.0','excel 5.0;hdr=no;imex=1;database=d:\test.xls',sheet1$)--访问临时表加with (nolock)select * from #t with (Nolock)
sp_lock查出来的是什么锁?加锁的对象是什么?
----------------------
把结果贴出来看看啊
51 1 85575343 0 TAB IS GRANT
52 12 5575058 0 TAB IX GRANT
52 12 0 0 DB S GRANT
52 12 5575058 2 KEY (6d018b3519c6) X GRANT
52 12 5575058 2 KEY (dd0032934a1f) X GRANT
52 12 1141579105 1 KEY (2b00dc0888a9) X GRANT
52 12 1141579105 1 PAG 1:151 IX GRANT
52 12 1141579105 0 TAB IX GRANT
52 12 5575058 2 PAG 1:167 IX GRANT
52 12 5575058 1 PAG 1:189 IX GRANT
52 12 5575058 1 KEY (d8004334cc30) X GRANT
52 12 5575058 1 PAG 1:206 IX GRANT
54 12 0 0 DB S GRANT