如何创建一个存储过程来检查行在另一个表中是否有引用？
这是我的密码：

Create Procedure dbo.usp_Delete
    @type dbo.udt_Delete ReadOnly
As  
Begin Tran
    Begin Try
        DELETE FROM dbo.File 
        WHERE EXISTS (SELECT p.Id FROM dbo.Payment p 
                      WHERE pt.Id = File.Id)