Please suggest some idea how to do this in sql

You can make the modulename and projectname as composite key in that case their combination will be unique and not individual values

http://stackoverflow.com/questions/1545571/how-do-i-make-a-composite-key-with-sql-server-management-studio

Sir,

I want the module name for that particular project name as unique. Ex

ERMS>Address

XYZ>Address

CAn be added.. So the module name i cant make it unique

For composite key you will need to make both primary key so that their combination is unique. I would like you try it atleast once

Ok will try..

I have modulemaster table

With ModuleID,ProjectID,ModuleName

So u mean i must make ProjectID and ModuleName as Composite key? ModuleName is varchar type

Yes set both columns as Primary key Thus it will become a composite key.

DataType does not matter