...
The examples in this section modify numeric properties, however it is fairly simple to modify the queries if you want to work with alphanumeric properties.
Based on object's ID
In this example, we are going to modify various numeric properties on a T-SQL object (a T-SQL Procedure called "DeleteAllOrders") that is synchronized with the CAST Analysis Service.
...
Code Block |
---|
select PROP_NAME, PROP_DESCRIPTION, VALUE from CTV_OBJECT_PROPERTIES where OBJECT_NAME = 'DeleteAllOrders' and PROP_TYPE = 'NUMERIC' go |
Based on object's GUID
For an object with an OBJECT_GUID
In this example, we are going to modify various numeric properties on a C++ object (a Global Function called "process_results ()") stored in the CAST Analysis Service.
...
You can also check in CAST Enlighten.
For an object without an OBJECT_GUID
In this example, we are going to modify various numeric properties on a T-SQL server object (a Procedure called "byroyalty") stored in the CAST Analysis Service.
The properties we are going to modify are
...