Assuming we have the following table (that stores hierarchical data) :CREATE TABLE [staff] ( [employee] [int] NOT NULL , [employee_name] [varchar] (10) NULL , [supervisor] [int] NULL , PRIMARY KEY CLUSTERED ( [employee] ) ON [PRIMARY] , FOREIGN KEY ( [supervisor] ) REFERENCES [staff] ( [employee] ))I ‘ll built a […]
2002-08-23
825 reads
2002-06-06
473 reads
--Implement an Alert Which Trigger when Specified Disks--free space exceeds a specified alert level--Steps to implement:--1) Define a Custom Error Message with messsage text (The ---drive free space is bellow alert level. Details: %s)--2) Define an Alert linked to CEM defined at step 1--3) Implement a Job which execute the following step in a recurring […]
2002-06-04
2,668 reads
By Steve Jones
This is my report, which continues on from the Oct report. It’s getting near...
By James-Serra
(Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th...
By John
Azure SQL offers up a world of benefits that can be captured by consumers...
This script reads thru a file and removes the last line, but before it...
Hello experts, I have a noob question as I never feel like I understand...
Hi all, need your help on conversion of excel formula into case statement. i...
Ask SSC