Helpful components right under your fingers

Use huge amount of integrated technologies to create best integrations

Microsoft SQL Server

SQL server (or MS SQL) is a top of the line database geared for the cloud

Categories: Data sources
Featured applications for   Microsoft SQL Server   connector
No applications available
Microsoft SQL Server   connector features
Actions
Custom query
  • Execute query with data set return

    Parameters:

      • Connection string, String
      • Custom query, String

    Returns:

    • result, Array [Object]
  • Execute query with scalar return

    Parameters:

      • Connection string, String
      • Custom query, String

    Returns:

    • result, Object
  • Data operations
  • Delete items from table

    Parameters:

    • Connection string, String
    • Table name, String
    • Filter, String

    Returns:

    • rowsAffected, Integer
  • Insert items into table

    Parameters:

      • Connection string, String
      • Table name, String
      • Items to insert, Array [Object]
      • Identity field name, String
      • Enable identity insert, Boolean

    Returns:

    • rowsAffected, Integer
  • Insert single row into table

    Parameters:

      • Connection string, String
      • Table name, String
      • Item to insert, Object
      • Enable identity insert, Boolean
      • Identity field name, String
      • Result format, Integer

    Returns:

    • updatedObject, Object
    • rowsAffected, Integer
  • Save items into table (using INSERT or UPDATE)

    Parameters:

      • Connection string, String
      • Table name, String
      • Items to insert, Array [Object]
      • Identity field name, String
      • Enable identity insert, Boolean
      • Compare by fields, Array [String]

    Returns:

    • rowsAffected, Integer
  • Select data from table

    Parameters:

      • Connection string, String
      • Table name, String
      • Fields, String
      • Filter, String
      • Sort by, String
      • Result format, Integer

    Returns:

    • data, Array [Object]
    • count, Integer
  • Update items in table

    Parameters:

      • Connection string, String
      • Table name, String
      • Update functions (e.g. Count=Count+2, Name='Test'), String
      • Filter, String

    Returns:

    • rowsAffected, Integer
  • Update single row in table

    Parameters:

      • Connection string, String
      • Table name, String
      • Identity field name, String
      • Item to update, Object
      • Result format, Integer

    Returns:

    • updatedItem, Object
  • Database management
  • Create new table

    Parameters:

      • Connection string, String
        • Table name, String
        • Fields description, Array [Object]

    Returns:

    • tableMetadata, Object
    • success, Boolean
    • reason, String
  • Delete table

    Parameters:

    • Connection string, String
    • Table name, String

    Returns:

    • success, Boolean
    • reason, String
  • Returns table metadata by name

    Parameters:

    • Connection string, String
    • Table name, String

    Returns:

    • tableName, String
    • fieldsMetadata, Array [Object]
  • Get tables list for database

    Parameters:

    • Connection string, String

    Returns:

    • tablesMetadata, Array [Object]
    • databaseName, String
    • success, Boolean
    • reason, String
  • Stored procedures
  • Execute procedure and returns array of results

    Parameters:

      • Connection string, String
      • Procedure name, String
      • Parameters, Array [Object]

    Returns:

    • isSuccess, Boolean
    • result, Object
  • Execute stored procedure with single return value

    Parameters:

      • Connection string, String
      • Procedure name, String
      • Parameters, Array [Object]

    Returns:

    • isSuccess, Boolean
    • result, Object
  • Execute stored procedure without return value

    Parameters:

      • Connection string, String
      • Procedure name, String
      • Parameters, Array [Object]

    Returns:

    • isSuccess, Boolean
    • result, Object
Triggers
Operations triggers
  • Activate event after item deleted from table

    Parameters:

      • Database connection string, String
      • Table name, String

    Returns:

    • tableName, String
    • item, Object
  • Activate event after new item inserted in table

    Parameters:

      • Database connection string, String
      • Table name, String

    Returns:

    • tableName, String
    • item, Object
  • Activate event after existed item update in table

    Parameters:

      • Database connection string, String
      • Table name, String

    Returns:

    • tableName, String
    • item, Object