No Duplication values

My problem is I want insert values without duplicating values.

AL开发者_开发技巧TER PROCEDURE [dbo].[SD_Sproc_Result]
    -- Add the parameters for the stored procedure here
        @employeeid varchar(100),
        @providercode varchar(100)

AS
BEGIN

        Insert into TR_employeesprovidercode (employeeid, providercode) values
        (@employeeid, @providercode)

END

Try this:

 IF NOT EXISTS(SELECT * FROM TR_employeesprovidercode
                   WHERE employeeid = @employeeid 
                   AND providercode = @providercode)
 BEGIN
      Insert into TR_employeesprovidercode (employeeid, providercode) 
      values (@employeeid, @providercode)
 END

Alternatively, you could create a unique constraint on the table containing the two columns employeeid and providercode.

ALTER TABLE myTable
ADD UNIQUE (employeeid, providercode);

You need to define some fields as unique and use INSERT IGNORE...

http://dev.mysql.com/doc/refman/5.5/en/insert.html

Read about the IGNORE keyword.

http://dev.mysql.com/doc/refman/5.0/en/constraint-primary-key.html

Read about unique-keys.