|
|
|
|
|
|
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=pas;Password=P@ssw0rd;|SELECT TOP 1 MachineName FROM dbo.Agent]
Opens a connection against a server named DEVELOPMENT as the pas 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 © 2024 pasUNITY, Inc.
Send comments on this topic.
Created with an evaluation copy of HelpSmith.
To remove this notice, you should purchase the full version of the product.
