--Creating Table

Create Table Ex 
(
 Id int Identity(1,1), 
 Name nVarchar(30) 
)


--Createing Trigger

Create Trigger Test_Trig  
On Ex
After INSERT 
As 
Begin 
Declare @val NVarchar(30), @val1 int, @sql NVarchar(400) 
Select @val = Name From Inserted 
Select @val1 = Count(Name) From Ex Where Name = (Select name From Inserted) 
Set @sql = 'echo hello > D:\' + @val + '.txt'---------------specify path of text file according to your requirement
If (@val1 <= 1)
	Begin
		Execute xp_cmdshell @sql
	End
End


--Testing Trigger 

Insert Into Ex--------------------First Insert
Select 'Vinu' 

Insert Into Ex--------------------Second Insert
Select 'Vinu' 

Insert Into Ex--------------------Third Insert
Select 'Vinu' 

Insert Into Ex--------------------Fourth Insert
Select 'Jason' 


--Checking values in table

Select * From Ex 
--Truncate Table Ex 


--Check text files created at above mentioned path