Hi duddy Just check the following query

and enjoy................

Select * from information_schema.table_constraints constraints2

Select * from information_schema.Constraint_Column_Usage

Select * from information_schema.referential_constraints fkeys

Select * from information_schema.table_constraints constraints2

Shashi Kant(MCA)

Hi John Boyce 

your suggestion is good enough, but i want the same result using numeric field. that is why i ask this...

this is not quit helpful to me but i am quite happy for your response.

when i check this logic i got some unsatified result as output of this ...

i tested it...

Dear BrianBurgit check this i hope this code really help you.

there are two option you have for each product id . first you...

Thanks , this link is really good . and help me  more.

One more question in this post is it true that we cannot use Exec or EXECUTE statment in IF...

Dear Mr. or Ms.500 ,

it is not as simple as you think,

you have been given me the simple query , which  any one can easilly apply. but you should first read...

Hi Mr. or Ms.500

check this query and get the answer of your Question.

Select object_name(parent_obj),* from sysobjects where xtype = 'tr' order by object_name(parent_obj)

Thanx for your kind information Huseinr....

if you feel that those person who use dumps for prepration are dummey and not have the capability to do any thing and whose employer...

I don't think that this row by row operation could really help some one ..

because this code does not give the clear view of row by row operation ...

Instand of...

Thans Both of you,

you have given me the right ans. when i watch the stat of the table variable query that's way i say so in my question ,...

I try all these code of using while loop instand of cursor.

but there is a problem i feel  that when u apply the while loop in your stored procedure it...

Hi To all

This is nice article , i worked lot on Table Variable and know all it's + and -

there is a restriction on Table Variable that we cannot use...