DBA常用SQL

 

1.

SELECT o.name SpName, c.name ColumnName, d.is_updated, d.is_selected, d.is_select_all 
FROM   sys.objects o 
JOIN   sys.sql_dependencies d ON o.object_id = d.object_id 
JOIN   sys.objects o2 ON o2.object_id = d.referenced_major_id 
JOIN   sys.columns c ON c.object_id = d.referenced_major_id 
AND c.column_id = d.referenced_minor_id 
WHERE  o2.name = 'PO_Receiving_Item' 
AND  c.name = 'InvoiceQty'