cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
607
Views
0
Helpful
1
Replies

syntax for Extract Rows from Table activity

davshapi
Level 1
Level 1

I have a global table variable with some SNMP commands in it for a process I am testing.

I need an example of the syntax that this activity is expecting in the WHERE clause. I tried using standard T-SQL expressions but it keeps giving me "Syntax error: Missing operand after [Field] operator"

An example of what I've got in there right now:

WHERE [Field] = '[process variable]'

I've also tried using -like

1 Reply 1

davshapi
Level 1
Level 1

Nevermind, figured it out. 

You exclude WHERE and just use Column_Name='value'

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: