员工 ID 自动生成，带前缀

我很困惑我希望员工 ID 是自动生成的前缀格式 我知道这可能是在 sql server 中触发之前发生的 我正在关注帖子http://www.aspdotnet-suresh.com/2012/04/set-custom-auto- generatedincrement.html http://www.aspdotnet-suresh.com/2012/04/set-custom-auto-generatedincrement.html

USE [test1]
GO

/****** Object:  Table [dbo].[Users]    Script Date: 03/08/2013 12:28:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Users](
    [UserId] [varchar](50) NOT NULL,
    [UserName] [varchar](50) NULL,
    [LastName] [varchar](50) NULL,
    [Location] [varchar](50) NULL,
 CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED 
(
    [UserId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

并且显示的是

    UserId  UserName    LastName    Location
08U13000    SureshDasari    Dasari  Chennai
08U13001    SureshDasari    Dasari  Chennai
08U13002    SureshDasari    Dasari  Chennai
08U13003    SureshDasari    Dasari  Chennai
08U13004    SureshDasari    Dasari  Chennai
08U13005    SureshDasari    Dasari  Chennai
08U13006    SureshDasari    Dasari  Chennai
08U13007    SureshDasari    Dasari  Chennai
08U13008    SureshDasari    Dasari  Chennai
08U13009    SureshDasari    Dasari  Chennai
08U13010    SureshDasari    Dasari  Chennai
08U13011    SureshDasari    Dasari  Chennai
08U13012    SureshDasari    Dasari  Chennai
08U13013    SureshDasari    Dasari  Chennai
08U13014    SureshDasari    Dasari  Chennai
08U13015    SureshDasari    Dasari  Chennai

如何在SQL中自动创建具有以下系列A001000001 ... A001xxxxxx的主键？ https://stackoverflow.com/questions/12152960/how-to-automatically-create-the-primary-key-that-has-the-following-series-a00100

但我想从触发器之前插入来做到这一点 这个触发器在同一个表和同一行中工作 前任 -

INSERT INTO Users (UserName,LastName,Location) VALUES('SureshDasari','Dasari','Chennai')

和用户ID自动创建？像--08U13015,08U13014

我是从插入插入表中执行此操作的，但错误无法插入插入或删除表中
或任何其他方法 请帮我 提前致谢

提供的答案是@marc_s https://stackoverflow.com/a/12153031/569436问题是如何做到这一点。

在你的情况下，它看起来像这样：

create table Users
(
  Id int identity (3000, 1),
  UserId as '08U1'+right('0000'+cast(Id as varchar(5)), 5) persisted,
  UserName varchar(50),
  LastName varchar(50),
  Location varchar(50),
  constraint PK_Users primary key (UserId)
)

我不会像建议的那样做here http://www.aspdotnet-suresh.com/2012/04/set-custom-auto-generatedincrement.html。如果您删除一行或在并发情况下，您将会有重复项。

SQL小提琴 http://sqlfiddle.com/#!3/a911c/1