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: