Database

SELECT
    ...
FROM
    t1
    INNER JOIN t2
    ON t2.CampusID = t1.CampusID
    INNER JOIN t3
    ON t3.StaffID = t1.StaffID
ORDER BY
    ...
;

DBCC CHECKDB (N'Your-Database-Name') WITH NO_INFOMSGS, ALL_ERRORMSGS;

Msg 3043, Level 16, State 1, Line 1
BACKUP 'broken' detected an error on page (1:143) in file 'c:\sql\mydb.mdf'.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

ALTER PROC [dbo].[DATABASE_MAINTANANCE_PLAN]
AS 
BEGIN
DECLARE @command nvarchar(max);
DECLARE @FillFactor int = 85;

    SET @command = N'ALTER INDEX ALL ON [?] REBUILD WITH (FILLFACTOR = ' + Convert(nvarchar(3), @FillFactor) + N')';
    EXEC sp_MSforeachtable @command; 
END

ALTER   TABLE table1 ADD
UNIQUE(column)

ALTER TABLE table2  ADD  

FOREIGN KEY (column) REFERENCES table1(column); 

srikrishnathanthri wrote:

Is it possible to set ''ON DELETE CASCADE" without adding primary key in the parent table ?

srikrishnathanthri wrote:

But I want to add "ON DELETE CASCADE" only for Place and State.

ALTER TABLE [dbo].[Product2]  ADD CONSTRAINT 
[FK_ProductDetails_Products] FOREIGN KEY([name],[place],[state])
REFERENCES [dbo].[Product1] ([name],[Place],[state])
ON UPDATE CASCADE
ON DELETE CASCADE

ALTER TABLE dbo.Product1
ADD CONSTRAINT UX_Product1_Name_Place_State
UNIQUE NONCLUSTERED (name, Place, state)

Introducing FOREIGN KEY constraint 'FK_ProductDetails_Products' on table 'Product2' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.

Error message 1785 occurs when you create a FOREIGN KEY constraint that may cause multiple cascade paths[^]:

[A] table cannot appear more than one time in a list of all the cascading referential actions that are started by either a DELETE or an UPDATE statement.