How to genrate automaticlly empid like gt001
Answers were Sorted based on User's Feedback
Answer / vijayalakshmi u
Create Table emp
(
dbID int NOT NULL IDENTITY (1,1) PRIMARY KEY,
customerNumber NVARCHAR(100) auto_increment,
Name Varchar(100)
)
Create function CustomerNumber (@id int)
returns varchar(10)
as
begin
DECLARE @ret varchar(10) ;
select @ret='gt' + right('0000' + convert(varchar(10), @id), 4)
RETURN @ret
end
create trigger emp_insert on emp
after insert as
update emp
set
emp.customerNumber = dbo.CustomerNumber(emp.dbID)
from
emp inner join
inserted on emp.dbID= inserted.dbID
Is This Answer Correct ? | 2 Yes | 0 No |
create a identity column and create a computed column which will br 'gt' concatenate identity column
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / dipak patil
Create Table emp
(
dbID int NOT NULL IDENTITY (1,1) PRIMARY KEY,
customerNumber NVARCHAR(100) ,
Name Varchar(100)
)
GO
----------------------------------------
Create Proc Usp_InsertRecord
@EmpName Varchar(10)
As
BEGIN
Declare @MAXValue Varchar(Max),@intValue Integer
SET @MAXValue='0'
SELECT TOP 1 @MAXValue=ISNULL(customerNumber,0) From emp Order by dbID DESC
Set @intValue=Convert(Integer,Replace(@MAXValue,'Gt',''))+1
SET @MAXValue='GT' + right('0000' + convert(varchar(10), @intValue), 4)
Insert Into Emp(customerNumber,Name) Values(@MAXValue,@EmpName)
END
----------------------------------------
-- Exec Usp_InsertRecord 'RAM'
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pravati
INSERT INTO TABLE NAME(EMPLOY ID) VALUES('gt_001')
Is This Answer Correct ? | 0 Yes | 0 No |
How to delete an existing database user?
What is merge replication?
what is the different types of backups available in sql server? : Sql server database administration
How do I connect to sql server database?
How can I check if a view exists in a sql server database?
Is the primary key column of a table an index in ms sql server?
Describe the functionalities that views support.
Does partitioning help performance?
Is resultset an interface?
What is Report Server,Report Manager and Report Builder in SSRS 2005?
How to encrypt data between dialogs?
Is truncate a dml command?