regarding the identity

• anjigvr

  Grasshopper

  Points: 15

  More actions

  June 23, 2009 at 5:06 am

  #139194

  my senario is

  i have table like Channel,ChannelBranch

  In that ChannelId is having Identity (1,1) in the Channel table

  ChannelBranchId is having Identity (1,1) in the ChannelBranch table

  when i give for all the table identity (1,1) it conflicts in front end in the WPF ,They don't want same identity

  for this i can give different Identites for each table like identity(1,1000000) identity(1,2000000)

  here also one problem records are getting large at one point identities are met with the some other table identity

  For this iam going to give identity with some string depends on the table name

  like ChannelBranch i want to insert CB1,CB2 ,CB3,CB4,CB5 ... instead of 1,2,3,4,5...

  Best solution is helpfull to me

• Pandian S

  SSChasing Mays

  Points: 625

  More actions

  June 23, 2009 at 5:23 am

  #1013838

  The IDENTITY column must be of data type int, bigint, smallint, tinyint,decimal or numeric with a scale of 0.