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<Match>()
.Select(x => x.Value);
foreach (var s in result)
Console.WriteLine(s);
}
}
dXNpbmcgU3lzdGVtOwp1c2luZyBTeXN0ZW0uQ29sbGVjdGlvbnMuR2VuZXJpYzsKdXNpbmcgU3lzdGVtLklPOwp1c2luZyBTeXN0ZW0uTGlucTsKdXNpbmcgU3lzdGVtLlRleHQuUmVndWxhckV4cHJlc3Npb25zOwoKcHVibGljIGNsYXNzIFRlc3QKewoJcHVibGljIHN0YXRpYyB2b2lkIE1haW4oKQoJewoJCXZhciB0ZXh0ID0gIklOU0VSVCBJTlRPIFRlc3RUYWJsZVxyXG4oXHJcbiAgICBUZXN0MSxcclxuICAgIFRlc3QyLFxyXG4gICAgVGVzdDMsXHJcbiAgICBUZXN0NCxcclxuICAgIFRlc3Q1XHJcbilcclxuVkFMVUVTXHJcbihcclxuICAgIEBUZXN0MSxcclxuICAgIEBUZXN0MixcclxuXHJcbiAgICBAVGVzdDMsXHJcbiAgICBAVGVzdDQsXHJcblxyXG4gICAgQFRlc3Q1XHJcbilcclxuXHJcblNFVCBASWQgPSBTQ09QRV9JREVOVElUWSgpIjsKICAgIAl2YXIgcmVzdWx0ID0gUmVnZXguTWF0Y2hlcyh0ZXh0LCBAIlxCQFx3K1xiKD8hXHMqPSkiKQogICAgCQkuQ2FzdDxNYXRjaD4oKQogICAgCQkuU2VsZWN0KHggPT4geC5WYWx1ZSk7CiAgICAgICAgZm9yZWFjaCAodmFyIHMgaW4gcmVzdWx0KQogICAgICAgIAlDb25zb2xlLldyaXRlTGluZShzKTsKCX0KfQ==