PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Collapse]User Manual for PANTHEON
   [Collapse]Getting Started
     First steps with PANTHEON
    [Expand]PANTHEON Installation
    [Expand]PANTHEON Basics
    [Collapse]PANTHEON System data
     [Expand]PANTHEON System data
     [Collapse]MS SQL Server
       Download and install MS SQL Server
       Upgrading the SQL Server to the newer version
       MS Management Studio - Download and install
       Restoring database onto SQL server
       Adding users to server level (AddUser_PAX)
       Installing SQL for external access
       Installing PANTHEON clients
      [Expand]MS SQL Server Security
      [Expand]Useful SQL Queries
       SQLExecute
      [Expand]SQL Server Jobs
     [Expand]Microsoft Windows Utilities
     [Expand]Security Policy
     [Expand]Database Administration
    [Expand]PANTHEON Security
    [Expand]Using PANTHEON at Tecta, a fictional company
    [Expand]Frequently asked questions about Pantheon (F.A.Q.)
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
    Creating new invoice
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]Service
   [Expand]Help
   [Expand]Personnel
   [Expand]Financials
   [Expand]Analytics
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
[Expand]User Site

Load Time: 1609.4057 ms
"
   4611 | 5321 | 338453 | Updated
Label

SQLExecute

SQLExecute

SQLExecute is a command-line utility for executing SQL queries. It is particularly useful in batch scripts (.bat files) and scheduled tasks, where SQL commands need to be executed automatically.

Parameters

SQLExecute accepts a number of command-line parameters.

Parameter Description
/U:xxxx User name for SQL Server login (SQL Server authentication).
/P:xxxx Password for SQL Server login.
/S:xxxx Name of the SQL Server instance.
/D:xxxxx Name of the database.
/F:xxxxx Full path and file name of the file containing the SQL code.
/A Automatically executes the specified script file.

 
 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!