示例查看代码：

CREATE VIEW [my_custom_view]
AS
  SELECT
    a1.[column_a],a1.[column_b],a1.[column_c],a1.[column_d]
  FROM
    [table_a] a1
    JOIN [table_b] b1 ON b1.[column_a] = a1.[column_b]

和NOLOCK声明：

SELECT 
  [column_a],[column_b]
FROM
  [my_custom_view] NOLOCK