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 |
What is the maximum size per database for sql server express?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What are data resources?
What is sql server query analyzer?
How do I connect to sql server database?
What is difference between process and thread? Explain lazy writer funcationality.
How to test subquery results with the exists operator?
How to convert a table data in XML format in sql server?
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?
Explain the database you used in your final year project?
What is inner join? Explain with an example?