Q&A for scientists using computers to solve scientific problems
CREATE TABLE #Teacher(TchrId VARCHAR(3), TeacherName VARCHAR(30)) INSERT INTO #Teacher SELECT 'T1', 'Mary' UNION ALL SELECT 'T2', 'Jim' CREATE TABLE #Student(StudId VARCHAR(3),TchrId VARCHAR(3), StudentName VARCHAR(30)) INSERT INTO #Student SELECT 'S1' , 'T1' , 'Vineeth' UNION ALL SELECT 'S2' , 'T1' , 'Unni' DELETE FROM #Teacher OUTPUT deleted.TchrId,deleted.TeacherName where TchrId = 'T1'