At isolation in select / readtext statement
Holdlock / NoHoldLock /Shared Table hint
Lock table <table_name> in {share | exclusive} mode
ReadPast
Set chained