Cisco Cisco Process Orchestrator 3.0
4-3
Cisco TEO Adapter Guide for Microsoft SQL Server Database
OL-24576-02
Chapter 4 Using Microsoft SQL Server Database Activities
SQL Server Database Adapter Activities
Common Wildcard Expressions
The following table describes are commonly used wildcard special characters that display according to
the selected activity.
the selected activity.
Insert Into SQL Server
Provides source table for data inserted a SQL Server
database
database
List SQL Server Running SQL
Queries
Queries
Queries the running SQL queries performed
.
Select from SQL Server
Queries table from SQL Server database
Select from TEO SQL Server Report
Database
Database
Queries data from a SQL Server report database
.
SQL Server Lock Information
Queries lock information from SQL Server database
Update SQL Server
Updates column information in the SQL Server database
using SQL command lines
using SQL command lines
Activity
Description
Character
Description
*
Match Any Character
#
Match Any Single Digit
?
Match Any Single Character