How to create trigger for generating names?

Question

1. Create trigger to generate Unicode code name for each trainee Example: vijay and today date as 02-07-2015 Vij_Nacre_02-07-2015

Jignesh Trivedi · 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

Arvind Chourasiya · Answer

working properly. Thank You Stupid Programmer.:)

Arvind Chourasiya · Answer

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

Jignesh Trivedi · Answer

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?