It is empty string

Thank you phil but ,, when imported again into the database is inserted as Space and not null so that makes a difference. As we are feeding into other applications,...

Thanks emily but still 'NULL' and NULL makes a difference when you import in the table.

Here is the sample data

...

Thanks Matija!!

But this will not fetch the tables within a procedure when the tables used in the procedure are from a different database.Please check my previous post for the requirement.

Try this

set rowcount 1

select 1

while @@rowcount > 0

delete Emp1 where 1 < (select count(*) from Emp1 a2

where Emp1.Eno = a2.Eno

and...

thanx i needed a scenario which has table with columns for different months.thanx anyways..i solved it.

You could use

sp_helpconstraint tblproducts

sp_help tblproducts

This will list you all the foreign keys the table is referring and also other Table referenceing this table.

Thanx a lot