Trigger to create a Primary key

• Aditya Narvekar

  Valued Member

  Points: 56

  More actions

  April 11, 2005 at 10:17 pm

  #88679

  Hi ,

  I am trying to create a before insert trigger which generates the primary key for each row being inserted in the table.  The primary key is going to be just a sequence of integers starting from 1 .  Is there a sequence object in SQL server?

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  April 11, 2005 at 11:23 pm

  #552025

  There is no sqquence object in SQL Server, instead there is an identity property for tables

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• David.Poole

  SSC Guru

  Points: 76001

  More actions

  April 12, 2005 at 1:23 am

  #552039

  CREATE TABLE dbo.Product (

  ID Int Identity (1,1) NOT NULL,

  ProductName VARCHAR(50) NOT NULL ,

  ...etc

  )

  The parameters of identity are the start value of the sequence and the increment.

  You can force numbers (if you have legacy data) into the ID field by putting

  SET IDENTITY_INSERT dbo.Product ON

  INSERT dbo.Product (ID,ProductName) VALUES (5,'Widgets')

  INSERT dbo.Product (ID,ProductName) VALUES (10,'Gadgets')

  SET IDENTITY_INSERT dbo.Product OFF

  LinkedIn Profile