title: is it possible to add duplicate values to usn column? this is the table i have created,how to add data something like i have shown in the example?
body: <pre><code>CREATE TABLE [dbo].[studentdb] (
      [usn]         VARCHAR (15) NOT NULL,
      [name]        VARCHAR (50) NOT NULL,
      [collegename] VARCHAR (50) NOT NULL,
      [eventid]     VARCHAR (15) NOT NULL,
      [passwd]      VARCHAR (50) NULL,
      [email]       VARCHAR (75) NULL,
      CONSTRAINT [PK_studentdb] PRIMARY KEY CLUSTERED ([usn] ASC, [eventid] ASC),
      FOREIGN KEY ([eventid]) REFERENCES [dbo].[eventdb] ([eventid])
  );
  </code></pre>
  
  <p>is it possible to add duplicate values to usn column?
  this is the table i have created,how to add data something like i have shown in the example?</p>
  
  <pre><code>USN  EVENTID
  1     100
  2     100
  3     200
  1     200
  3     100
  4     100
  5     100
  5     200
  </code></pre>