There would be a mapping layer that moves existing data to the exposed variables.
In the example provided I have created an update stored procedure that could be tied directly to a function that would activate or inactivate a student.
The following example is for creating a simple update stored procedure.
You can run it through an explicit call from a host language program or directly from a DBMS query execution shell like SQL Server Management Studio or db Orchestra.
The latest build of the external application is still available for download, but all new development efforts will target the SSMS Addin only. If you happen upon a bug, please log it in the Issue Tracker for this Project.
Students SET active_flg = ISNULL(@active_flg , active_flg) FROM dbo.
Linked servers are especially useful when configuring the OLE DB data source on each client computer is too time-consuming.
Master Data Services (MDS) is the SQL Server solution for master data management.
If you have a request for a feature, please open a discussion or a Issue in the Issue Tracker so that the request can be considered for inclusion in the project.
A number of the most recent changes have been based on feedback that has been received from people regarding the tool and how it could be better.