Generate unique value in MS SQL

Question

I have primary key unique column ID nchar(10). I'm planning to generate in it numeric ID. Incremental order is ok, but not necessary. How to make optimal generator for this reason? Should I use stored procedure? Maybe MS SQL server have any features for this reason?

Answer 1

DECLARE PkStudentid as INT

CREATE TABLE Student 
(
 Studentid int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
 Firstname nvarchar (200) NULL,
 Lastname nvarchar (200),
 Email nvarchar (100) NULL
)

insert into Student (Firstname,Lastname,Email)
Values('Vivek', 'Johari', ‘[email protected]');

SET @PkStudentid  = SCOPE_IDENTITY();

print @PkStudentid

This will insert Studentid as 1 and next entry 2 and in increment order.

You need to use IDENTITY property in SQL Server.

Edited : use SCOPE_IDENTITY in SQL Server to get back latest inserted Studentid.