Le Kevin Blog Blog


To get list of tables used in a stored procedure

;WITH stored_procedures AS ( SELECT o.name AS proc_name, oo.name AS tables_used_in_procedure, ROW_NUMBER() OVER(partition BY o.name,oo.name ORDER BY o.name,oo.name) AS ROW FROM sysdepends d INNER JOIN sysobjects o ON o.id=d.id INNER JOIN sysobjects oo ON...


Install Mac OS on Dell Precision 690 Workstation

Lastest: The following guide is a complete walkthrough for updating to or installing a fresh version of macOS Sierra. It requires no experience and all of the basic installation and post-installation tools are available...