using System; using System.Collections.Generic; using System.IO; using System.Linq; using System.Text.RegularExpressions; public class Test { public static void Main() { var text = "INSERT INTO TestTable\r\n(\r\n Test1,\r\n Test2,\r\n Test3,\r\n Test4,\r\n Test5\r\n)\r\nVALUES\r\n(\r\n @Test1,\r\n @Test2,\r\n\r\n @Test3,\r\n @Test4,\r\n\r\n @Test5\r\n)\r\n\r\nSET @Id = SCOPE_IDENTITY()"; var result = Regex.Matches(text, @"\B@\w+\b(?!\s*=)") .Cast() .Select(x => x.Value); foreach (var s in result) Console.WriteLine(s); } }