Client Applications in SQL Server

Please wait 0 seconds...
Scroll Down and click on Go to Link for destination
Congrats! Link is Generated


Users do not directly connect to SQL Server and its analytics tools, but through the separate client, applications connect to the data. These applications connect to SQL Server using:


Transaction -SQL

This language is a version of Structure Query Language (SQL)It is the main language used by SQL Server.

XML _

This format returns data from queries and stored procedures using URLs and templates over HTTP XML can also be used to insert, delete and update data in databases.

Distributed management of MDX objects

Enables the definition of distributed management modes for objects, queries, and multidimensional data manipulation in OLAP data analysis databases.

OLE DB interfaces and ODBC

Client applications use the Object Linking and Embedding Database (OLE DB) interface. Open Database Connectivity (ODBC), via the communication interfaces of programs and programming languages ​​that enable sending commands to databases using Transaction-SQL.

ActiveX Data Objects (ADO)

Enable ActiveX objects to use OLE DB objects' linking and embedding property programming languages ​​such as Microsoft Visual Basic Active Server Pages (ASP)

Microsoft Internet Explorer Visual Basic Scripts.

Using ADO ActiveX Objects To access OLTP databases uses ActiveX Multidimensional objects to access data analysis services and data cubes.

English Query

They are applications that provide an application interface that enables users to ask questions (verbally) in English instead of writing complex queries to databases that are answered in spoken language. For example, questions such as“ What are the total sales in region 1?”.


Client -Server Component

SQL Server consists of a set of server and client components to store and retrieve data. SQL Server uses communication layers to isolate applications from the network layer and protocols, and they can build from packages and install the same application in different network environments.


Client-Server Architecture

SQL server uses a client-server architecture to separate the workload of tasks on server machines and those on client machines.

  • The customer is responsible for the business logic and provides data to the user, and the client's tasks can be simulated on more than one computer and it can also work on a server other than the SQL Server server.
  • SQL Server manages databases on the server and there are resources such as memory network bandwidth and disk operations during multiple requests.

The client-server building enables the design, package, and installation of applications in different environments. Programming client interfaces provide the means to enable applications to work on separate client devices connected to the server through the network.



𝔀𝔀𝔀 𝐍𝐢𝐚𝐃𝐙𝐆𝐍 𝕔𝕠𝕞

Post a Comment

Please don't share any sensitive or personal details here.

Cookie Consent
We serve cookies on this site to analyze traffic, remember your preferences, and optimize your experience.
Oops!
Your Internet Connection is weakened. Please try Refreshing your Browser or Check your Internet Connection...
AdBlock Detected!
We have detected that you are using adblocking plugin in your browser.
The revenue we earn by the advertisements is used to manage this website, we request you to whitelist our website in your adblocking plugin.
Site is Blocked
Sorry! This site is not available in your country.