IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = 'sp_WhoIsActive') EXEC ('CREATE PROC dbo.sp_WhoIsActive AS SELECT ''stub version, to be replaced''') --If 1, gets the full ...
INNER JOIN DEPT AS D (nolock) ON (P.deptCode = D.deptCode) INNER JOIN PATIENT AS PP (nolock) ON (P.Hn = PP.hn) INNER JOIN Nation AS N (nolock) ON (PP.nation = N.NATCODE) ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results