Revindex Task Scheduler

Export Print

Query database (SQL)

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.


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

Comments

Add comment

Powered by Revindex Wiki