ALTER TABLE dbo.User ADD CONSTRAINT ucCodes UNIQUE (fcode, scode, dcode)
CREATE UNIQUE INDEX uq_yourtablename ON dbo.yourtablename(column1, column2);