Extract SQL Parameter names from a string

Question

I'm implementing my own DBCommand like wrapper for our proprietary database through which we can only access via API and by using strings. Boooo

I want to be able to find via Regular Expression my normal parameters and not select the @@IDENTITY field (or anything else like that). I'm then going to replace the parameter name with the real value of that parameter NULL or 'Some Value' etc.

Currently I have

@\w{1,}

Given a string

INSERT INTO MYTABLE(VALUE1, VALUE2) VALUES (@MyValue1, @MyValue2); SELECT @@IDENTITY

I'm matching

@MyValue1
@MyValue2
@IDENTITY

I also tried [^@]@\w{1,} but it matches (@MyValue1 and _@MyValue2 (underscore representing space)

How can I not match @@Identity?

Anton Kovalenko · Accepted Answer · 2013-01-17 22:47:51Z

3

You can add paretheses, marking the subexpression whose matching string you actually want to use: [^@](@\w{1,}), then use Match.Groups(1) to retrieve that part only.

Another variant is a negative look-behind assertion: (?<!@)@\w{1,}, with an additional bonus of matching @name in the very beginning of the string (well, it probably won't happen).

Update: and it won't help you for '@quoted @string @literals', which are legitimate SQL, but not parameters

answered Jan 17, 2013 at 22:47

Anton Kovalenko

21.6k2 gold badges41 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hamlet Hakobyan · Accepted Answer · 2013-01-17 22:47:46Z

2

Try this,i assume this what you want.

(?<!@)@\w+

answered Jan 17, 2013 at 22:47

Hamlet Hakobyan

33.5k6 gold badges55 silver badges70 bronze badges

Comments

John Koerner · Accepted Answer · 2013-01-17 22:48:21Z

2

You could use a lookbehind to ensure it doesn't start with 2 @:

(?<!@)@\w{1,}

answered Jan 17, 2013 at 22:48

John Koerner

38.2k8 gold badges92 silver badges142 bronze badges

Collectives™ on Stack Overflow

Extract SQL Parameter names from a string

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related