@all : Thanks for the time!

/*Problem here is that we don't know what you have done on your own to answer this question as you don't say anything in that regard. In addition, your initial...

I guess we can also use unique not null to enforce referential integrity

sorry if i am wrong

Please do not comment without knowing the fact that whether i have googled or not.

i thought that the experts in sqlservercentral would give me a better clear answer thats y...

as far as i have understood,

we are making unique key to behave as primary key by enforcing not null constraint on it.

by default clustered index is created on a primary...

Thank you for your reply.

Sqlservercentral is best place to post this question.

Kindly help me out.

homework..

i want to know the basic performance difference between them.

yes i tested it.It worked fine.Before using it,i wanted sqlexperts to check and confirm the script.

I wanted someone to confirm that the query posted by me will display parent procedure.

Thank u mates.!

didnt get reply for >2 days.thats y posted it here.

Thanks for replying..!

declare @objid as int

select @objid=object_id from sys.objects where name='substitute your Procedurename'

if exists(select id from sysdepends where depid=@objid)

begin

select name as ParentProcedure from sys.objects where object_id in

(select id from sysdepends where depid=@objid)

end

else

begin

print...

Thank you mate:-)

any comments on this?

after seeing sp_executesql in sqlservercentral homepage,I started searching about it.