0

Please login or register to vote for this query.

(click on this box to dismiss)

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'

fork query

edited may 23 anonymous

created apr 22 15 Sarath Avanavu