SQLLookup

 

 

 

SQLLookup

 

Description

Performs a lookup against a SQL Server database server.

 

Arguments

1.SQLLookup - Name of the Macro.

2.Connection String - The SQL Server connection string to open a connection against.

3.Query - The Transact-SQL query to execute.

 

Examples

[SQLLookup|Data Source=DEVELOPMENT;Initial Catalog=TEST;User ID=transfer;Password=P@ssw0rd;|SELECT TOP 1 MachineName FROM dbo.Agent]

Opens a connection against a server named DEVELOPMENT as the transfer user and queries an Agent table in the TEST database for a machine name.

 

Notes

If multiple matches are found the value returned is the first column of the first row.  All other results are ignored.

 


Copyright © 2022 pasUNITY, Inc.

 

Send comments on this topic.