The Microsoft SQL based server is a type of relational database management system. The basic query language is the Transact – SQL, which is the implementation of the ISO/ANSI standard SQL (Structured Query Language) used by both Sybase and Microsoft.
The Microsoft SQL server makes use of the variant of the SQL called as the T-SQL, which is implementation of the SQL-92. The T (Transact)-SQL chiefly adds the additional syntax for usage in the stored procedure and affects the language of the transaction support.
The SQL server includes the support of the database clustering and mirroring. The SQL clustering is the collection of identical configured servers that aid in distribution of the workload among the multiple servers. All servers share the identical virtual name and are resolved in the IP address of the identical configured machines simply by clustering the runtime. The automatic failover clustering is available where the workload of the server gets transferred to other system in case of system failure. The SQL server supports data partition for distributed databases. Introduced in the SQL Server 2005, the database mirroring allows creating the replicas of the contents of the database with the transaction logs, on other instance of the SQL server, simply based on some kind of predefined triggers.
What exactly is SQL?
You might have noticed that most of the computer products include the word SQL. This is often pronounced as “sequel”. Whenever there is discussion of databases, the term SQL arises quite often. It’s a language that most of the relational types of databases understand. Database query is when the user asks for a database and the SQL is a language in which the query is written.
You do not actually need to know too much about SQL for operating a database.
The syntax for the SQL friendly database for creation of clients table is as follows:
CREATE TABLE clients (name TEXT, id number INT PRIMARY KEY, telephone TEXT, Address TEXT);
This will create columns. The ID number column if the PRIMARY KEY table which has to be very unique. Therefore, the database won’t permit you to assign different ID numbers for two or more clients. INT means the integer (Number) and the TEXT means characters.
For inserting data in your new table, you can use this SQL command:
INSERT INTO clients VALUE (‘Aaron Sanders’,'122′,’new york’,'3223232332′);
This will add a client with name, client ID, address and telephone no. Once you are finished with your data, you can run the searches by using the SQL command in this way:
SELECT name, ID number, address from the clients WHERE city = ‘New York’;
This will automatically retrieve all the clients located in New York.
Now you must have understood that SQL is a simple language and very simple queries are straight forward to understand. Actually, the real strength of the databases comes from very complex queries. Slightly complex queries like the clients telephone number starting from 98765 can also be done by giving SQL commands. The SQL actually looks complex, but once you understand the concept of SQL, you can easily start making your own SQL commands.
Related articles:
