# mssqlQuery

## Description

Query languages are used to make queries in a database, and Microsoft Structured Query Language (SQL) is used to query, insert, update and modify data.

## Input / Parameters

| No | Name      | Description                                                                                  | Data Type | Required |
| -- | --------- | -------------------------------------------------------------------------------------------- | --------- | -------- |
| 1  | connector | Name of connector and created in the Services and Global Components page.                    | String    | Yes      |
| 2  | query     | A query is a request for data or information from a database table or combination of tables. | String    | Yes      |

## Output

## Callback

## Video

## Example

The user wants to call the mssqlQuery Web Service.

### Step

1. To create MSSQL Connector in Services and define the name, url, port, database, user, password and timeOut.\
   Name: mssql\
   url: mkals4utt4.database.windows.net port: 1433\
   database: emobiq\_demo\_1\
   user: sqladmin\
   password: \*\*\*\*\*\*\*\*\
   timeOut: 5000

   ![](https://399701567-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwmJ1RKjM2uNFaL6fO3Xu%2Fuploads%2Fgit-blob-2ffccd4d125ddf82104bdb1c79c6bfd7d794b580%2FmssqlQuery-step-1.png?alt=media)
2. Call the function "mssqlQuery"and define the connector and query.\
   connector: mssql\
   query: select \* from user\_package<br>

   ![](https://399701567-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwmJ1RKjM2uNFaL6fO3Xu%2Fuploads%2Fgit-blob-61bfb9fb8f5e05d8cddfc8bcc05d13d4d7a0053b%2FmssqlQuery-step-2.png?alt=media)
3. Add a console for display the response from console.<br>

   ![](https://399701567-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwmJ1RKjM2uNFaL6fO3Xu%2Fuploads%2Fgit-blob-135524ac23c9a177492dec74b50639bf4dc5f22b%2FmssqlQuery-step-3.png?alt=media)

### Result

![](https://399701567-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwmJ1RKjM2uNFaL6fO3Xu%2Fuploads%2Fgit-blob-35d7f1daccb696dccfb307292e2026a2c7f3e9bb%2FmssqlQuery-result-1.png?alt=media)

## Links