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

What is the maximum size per database for sql server express?

0 Answers  


How to get a list of columns in a view using "sys.columns" in ms sql server?

0 Answers  


What are data resources?

0 Answers  


What is sql server query analyzer?

0 Answers  


How do I connect to sql server database?

0 Answers  






What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,


How to test subquery results with the exists operator?

0 Answers  


How to convert a table data in XML format in sql server?

0 Answers  


After the SQL installation what are the jobs will you configure?

1 Answers   G7 CR Technologies, IBM, Satyam,


What is the difference between stored procedure and functions?

0 Answers   MCN Solutions,


Explain the database you used in your final year project?

0 Answers   Wipro,


What is inner join? Explain with an example?

0 Answers  


Categories