Sql Stored Procedure

[mahesh123]

Hi,

I have to write stored procedure for delete
i am using SQL Server 2005 as my database.
I can delete directly by writing stored procedures simply to delete.But i have to check the condition to find weather the ID i am going to delete is used as Foreign key in another table.If it is used it should not be deleted.

Can anyone help me.
Thank you

[Plater]

So create your procedure and have it take the ID as a parameter.
Check to see if the record for the ID has that value that could be a foreign key, if it doesn't delete it.