MSSQL CRUD

In this post, we will look at, how we can perform CRUD operation on MSSQL Database.

Assumptions:

1. vutil is installed.
2. MSSQL connection is configured in the config.json file in vutil directory.

First create a test case which will fire a HTTP request on vutil server to validate the database state:

CRUD Operations:

1. Insert Query
   Insert query can be specified as shown in the following screenshot:
    
2. Select Query
   Select query can be specified as shown in the following screenshot:
   
3. Update Query
   Update query can be specified as shown in the following screenshot: 
    
4. Delete Query
   Delete query can be specified as shown in the following screenshot: