ALTER Trigger Tenant_room_check On Tenant
Instead Of Insert, Update
AS
Begin

   Declare 
    @Tenant_Count Int
   ,@Bedroom_Count Int

   Select @Tenant_Count = Count(Distinct T.Tenant_ID)

Create Trigger Tenant_room_check On Tenant
Instead Of Insert, Update
Begin

   Declare 
    @Tenant_Count Int
   ,@Bedroom_Count Int

   Select @Tenant_Count = Count(Distinct T.Tenant_ID)
   From Tenant T
   Inner Join Inserted I On T.TenantID = I.TenantID
                   And T.House_ID

 

SELECT     TENANT.*, STUDENT.*, PROFESSIONAL.*
FROM         TENANT INNER JOIN
                      STUDENT ON TENANT.TENANT_ID = STUDENT.TENANT_ID INNER JOIN

select distinct * 
from tenant t, student s, professional p, house h
where t.tenant_ID = s.tenant_ID
and t.house_id = 1
or t.tenant_ID = p.tenant_ID
and t.house_id = 1

SELECT     H.* 
FROM         HOUSE H               
WHERE     H.HOUSE_ID = 2;

SELECT     COUNT(R.ROOM_NAME) AS Rooms
FROM         HOUSE

IF EXISTS(SELECT name FROM abacus..sysobjects WHERE name = 'OWNER')
DROP TABLE OWNER
CREATE TABLE OWNER
 (OWNER_ID INT IDENTITY(1,1) NOT NULL Primary KEY
 ,OWNER_NAME VARCHAR(50)
 ,OWNER_ADDRESS1 VARCHAR(50)
 ,OWNER_ADDRESS2 VARCHAR(50)
 ,OWNER_ADDRESS3 VARCHAR(50)
 ,OWNER_POSTCODE VARCHAR(50)
 ,OWNER_HOUSE_ID INT )

IF EXISTS(SELECT