Revindex Task Scheduler

Query database (SQL)

Last updated on 2024-02-12 1 mins. to read

To query data from the database, simply enter your SQL statements. You can use the special {databaseOwner}{objectQualifier} tokens to optionally translate object qualifiers. For example, the SQL statements below will update the Test table with some random text.

SET QUERY_GOVERNOR_COST_LIMIT 120 -- Optionally set command timeout to 120 seconds

DECLARE @myText varchar(100)
SET @myText = 'Hello'
INSERT INTO {databaseOwner}{objectQualifier}Test (Name) VALUES (@myText)
UPDATE {databaseOwner}{objectQualifier}Test SET Name = 'something else'


Powered by Revindex Wiki