Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- begin tran
- truncate table MSDS_PROD_BK..MSDS_Import
- insert into MSDS_PROD_BK..MSDS_Import
- select * from MSDS_PROD..MSDS_Import (nolock)
- commit tran
- SELECT distinct FILE_DATA
- FROM MSDS_Import
- WHERE FILE_NAME = ‘example.pdf’
- dbid ObjId IndId Type Resource Mode Status
- 75 0 0 MD 2(35e8b1ea:b:0) Sch-S GRANT
- 75 0 0 MD 1(35e8b1ea:a:0) Sch-S GRANT
- 75 0 0 MD 2(35e8b1ea:a:0) Sch-S GRANT
- 75 0 0 MD 1(35e8b1ea:b:0) Sch-S GRANT
- 75 0 0 MD 2(35e8b1ea:9:0) Sch-S GRANT
- 75 0 0 MD 1(35e8b1ea:8:0) Sch-S GRANT
- 75 0 0 MD 2(35e8b1ea:8:0) Sch-S GRANT
- 75 0 0 MD 1(35e8b1ea:9:0) Sch-S GRANT
- 75 0 0 MD 2(35e8b1ea:3:0) Sch-S GRANT
- 75 0 0 MD 1(35e8b1ea:3:0) Sch-S GRANT
- 75 0 0 MD 2(35e8b1ea:1:0) Sch-S GRANT
- 75 0 0 MD 1(35e8b1ea:1:0) Sch-S GRANT
- 75 0 0 MD 1(35e8b1ea:1:0) Sch-S GRANT
- 75 0 0 MD 2(35e8b1ea:7:0) Sch-S GRANT
- 75 0 0 MD 1(35e8b1ea:6:0) Sch-S GRANT
- 75 0 0 MD 2(35e8b1ea:6:0) Sch-S GRANT
- 75 0 0 MD 1(35e8b1ea:7:0) Sch-S GRANT
- 75 0 0 MD 2(35e8b1ea:5:0) Sch-S GRANT
- 75 0 0 MD 1(35e8b1ea:4:0) Sch-S GRANT
- 75 0 0 MD 2(35e8b1ea:4:0) Sch-S GRANT
- 75 0 0 MD 1(35e8b1ea:5:0) Sch-S GRANT
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement