Examples of using MS SQL server in English and their translations into Czech
{-}
-
Colloquial
-
Official
Access from PROMOTIC to MS SQL Server.
The MS SQL Server Agent service is not available.
For next descriptions to the MS SQL Server, see.
See: MS SQL Server- description, installation and management.
Text console for MS SQL Server administration.
MS SQL Server or MS SQL Server Express installation.
Database support for MS SQL Server or Firebird.
The MS SQL Server Compact usage is free of charge.
Disadvantages and limitations of MS SQL Server Compact.
Advantages of using MS SQL Server or MS SQL Server Express in the PROMOTIC system.
Disadvantages and limitations of MS SQL Server 2012 Express.
Using the internal language Transact SQL to program various data controls, calculations, filters,directly into the MS SQL Server.
No charge for MS SQL Server Express using.
It is possible to set some PROMOTIC components to write its data into the MS SQL Server Compact e.g.
The MS SQL Server is a database machine enabling to store, process and search larger data volumes for other programs on local computer or via the network.
Connecting the PmAdo object("/TestAdoDb") to the database("pm_data"),for MS SQL Server local instance named.
In order to enable the installed MS SQL Server or MS SQL Server Express for PROMOTIC apllicalions, it is necessary to complete the basic configuration.
If necessary for smaller database applications,it is possible to use the freeware versions of MS SQL Server Express, together with the PROMOTIC system.
During the installation of MS SQL Server or MS SQL Server Express it is necessary to enable the user authorization provided by the MS SQL Server. .
Especially fixing the performance limitation when executing parallel queries,expanding the database size from 4GB for MS SQL Server 2005 Express.
Thanks to the consistent core, data andprograms are stored in the MS SQL Server Express fully compatible with charged versions of the MS SQL Server.
That's why it is suitable to change the database context to the required working database by this command after starting the text console for MS SQL Server administration.
Otherwise the user authorization would be based only on OS Windows NT and the MS SQL Server configuration for the use of PROMOTIC system would be more complicated.
By means of the PmAdo and PmDatabase objects the user has access to databases of several types, for example: dBase, Excel, Microsoft Access, PARADOX,FoxPro, MS SQL Server, MySQL, Oracle, etc.
MS SQL Server and MS SQL Server Express are installed via the correstponding installators and can be installed as anonymous or named MS SQL Server instance.
For the purposes of small applications andtesting, it is possible to use the freeware version of MS SQL Server Compact together with the PROMOTIC system.
The MS SQL Server Compact differs from other MS SQL Server versions by the fact that all data of a single database are stored in a single file( SDF), located usually in the application data folder.
By calling the method it is possible to do backward writing on setting the Storage configurator to Database MS SQL server cyclic or Database Access cyclic.
In order to enable the installed MS SQL Server or MS SQL Server Express to be used by PROMOTIC applications, it is not necessary to complete configuration as it is needed fro standard MS SQL Server.
It can be used any version of the SQL Server in the PROMOTIC system,including versions of MS SQL Server Express or MS SQL Server Compact, which are free of charge.