如何在SQLSERVER中为自动编号编写SP? [英] How to write SP for AutoNumber in SQLSERVER?

问题描述

谁能帮我写一个存储过程.我想生成一个自动编号.
我有一个包含三个字段的表，如EmpCode，EmpName，EmpDesignation
当用户输入他或她的名字时，EmpCode会自动生成，如

SD0001 GAUTAM BISWAS SW
SD0002 SANJEEV KUMAR EXEC
SD0003 RAHUL BOSE AM

请帮助我进行存储过程.

我试过了

Hi,
Can anyone help me write a storedprocedure.i want to generate an autonumber.
i have a table which consists of three fields like EmpCode,EmpName,EmpDesignation
When the user enters his or her name,the EmpCode automatically gets generated like

SD0001 GAUTAM BISWAS SW
SD0002 SANJEEV KUMAR EXEC
SD0003 RAHUL BOSE AM

pls help me with the stored procedure.

I tried this

CREATE PROCEDURE dbo.EMP
  @EMPID nvarchar(15),
  @Identity int OUT
AS
INSERT INTO Categories (EMPID) VALUES(@EMPID)
SET @Identity = SCOPE_IDENTITY()

Is this Correct or Wrong ?

推荐答案

您需要像这样创建表

You need to create your table like that

CREATE TABLE Employee(
  EmpIdID int IDENTITY NOT NULL, 
  EmpCode as ''SD000''+Cast(EmpIdID as Varchar(10)) PERSISTED PRIMARY KEY, 
  EmpName Varchar(200),
  EmpDesignation Varchar(200)
)

这篇关于如何在SQLSERVER中为自动编号编写SP?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！