Need help on trigger Program.... | SQL Server

forum.venkateswarlu.net

Need help on trigger Program....

Anilkumar Murakonda #1
Member 14 Points	Posted on 09 Feb 2012 08:04 AM IST I have contact Table Contact_ID Name MMS_Contact_ID(Varchar) 1 A MMSC000001 2 B ..... When am inserting new records in Contact table (ID,Name) I want to Update the MMS_Contact_ID Column (MMSC000002)... then we insert records again, MMS Column should be genrated automatically .... Please write this Program in trigger .....
	SQL Server 671 views Reply to this topic

		Jahnavi N 164 Points
		Subramaniam R 152 Points
		Kalyan Suman 150 Points
		Cherukuri Venkateswarlu 140 Points
		Harikrishna Sikhakolli 108 Points
		Aisha Bobby 96 Points
		Gaurav Dutt 62 Points
		Saravanan Ramamoorhty 58 Points
		MalliKarjuna Cherukuri 52 Points
		Etuuj Dgg 48 Points