How to create trigger for generating names?

Jignesh Trivedi10y ago

Accepted answer

Hi,

Try following code, it might help you.
Create table #emp
(Id int, name varchar(50))

Insert into #emp values(1,'Jignesh')
Insert into #emp values(2,'Tejas')

select name + '_Welcome_' + CONVERT(char(10), GetDate(),126) from #emp

+1

Arvind Chourasiya10y ago

working properly.

Thank You Stupid Programmer.:)

0

Arvind Chourasiya10y ago

Jignesh Nacre character we have to append with result,it's not mandatory we can use hello,welcome etc instead of Nacre.One more thing this not a trigger it's only select query.when we execute query,it result all emp names like vijay to vijay_Welcome_2015-11-17,date is current date.help me?

0

Jignesh Trivedi10y ago

Hi Arvind,

We need some more information like you have enter Vijay as name and code will be vij_Nacre_...

so Is there any specific requirement of character?

0