How to genrate automaticlly empid like gt001

Answers were Sorted based on User's Feedback



How to genrate automaticlly empid like gt001..

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

How to genrate automaticlly empid like gt001..

Answer / trainedforjob

create a identity column and create a computed column which will br 'gt' concatenate identity column

Is This Answer Correct ?    0 Yes 0 No

How to genrate automaticlly empid like gt001..

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

How to genrate automaticlly empid like gt001..

Answer / pravati

INSERT INTO TABLE NAME(EMPLOY ID) VALUES('gt_001')

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to delete an existing database user?

0 Answers  


What is merge replication?

0 Answers  


what is the different types of backups available in sql server? : Sql server database administration

0 Answers  


How do I connect to sql server database?

0 Answers  


How can I check if a view exists in a sql server database?

0 Answers  






Is the primary key column of a table an index in ms sql server?

0 Answers  


Describe the functionalities that views support.

0 Answers  


Does partitioning help performance?

0 Answers  


Is resultset an interface?

0 Answers  


What is Report Server,Report Manager and Report Builder in SSRS 2005?

1 Answers  


How to encrypt data between dialogs?

0 Answers  


Is truncate a dml command?

0 Answers  


Categories