SQL vs Microsoft SQL Server | SQL vs SQL Server Qhov txawv
Structured Query Language (SQL) yog hom lus hauv computer rau databases. Nws yog siv rau kev nkag mus thiab tswj cov ntaub ntawv hauv Relational Database Management Systems (RDMS). Microsoft SQL server yog Relational Database Server tsim los ntawm Microsoft. Nws siv SQL raws li nws cov lus nug thawj.
SQL muaj lub peev xwm los ntxig cov ntaub ntawv rau hauv cov ntaub ntawv, nug cov ntaub ntawv rau cov ntaub ntawv, hloov kho / tshem tawm cov ntaub ntawv hauv cov ntaub ntawv thiab tsim / hloov kho database schema. SQL tau tsim los ntawm IBM thaum ntxov 1970s thiab tau pib hu ua SEQUEL (Structured English Query Language). SQL lus muaj ntau yam lus hu ua clauses, kab lus, predicates, queries thiab nqe lus. Ntawm cov no, feem ntau siv dav yog cov lus nug. Cov lus nug yog txhais los ntawm tus neeg siv nyob rau hauv xws li ib txoj kev uas nws piav qhia txog cov khoom uas xav tau ntawm lub subset ntawm cov ntaub ntawv uas nws yuav tsum tau retrieve los ntawm lub database. Tom qab ntawd Database Management System ua qhov tsim nyog optimizations rau cov lus nug thiab ua tiav cov haujlwm tsim nyog lub cev los tsim cov txiaj ntsig ntawm cov lus nug. SQL kuj tso cai rau cov ntaub ntawv hom xws li cov cim cov hlua, cov hlua me ntsis, cov lej thiab hnub tim thiab lub sijhawm muab tso rau hauv txhua kab ntawm cov ntaub ntawv. American National Standard Institute (ANSI) thiab International Organization for Standardization (ISO), tau txais SQL raws li tus qauv hauv 1986 thiab 1987 raws li. Txawm hais tias SQL yog tus qauv ANSI, muaj ntau yam sib txawv ntawm cov lus SQL. Tab sis kom ua raws li ANSI tus qauv tag nrho cov qauv no txhawb nqa cov lus txib dav dav xws li SELECT, HLOOV, DELETE, INSERT, NTAWM qhov chaw zoo sib xws.
Raws li tau hais ua ntej, Microsoft SQL server yog database server uas siv SQL, tshwj xeeb tshaj yog, T-SQL thiab ANSI SQL raws li nws cov lus nug tseem ceeb. T-SQL txuas ntxiv SQL los ntawm kev ntxiv ntau yam xws li cov txheej txheem kev ua haujlwm, cov hloov pauv hauv zos thiab txhawb kev ua haujlwm rau txoj hlua / cov ntaub ntawv ua haujlwm. Cov yam ntxwv no ua rau T-SQL Turing ua tiav. Txhua daim ntawv thov, uas xav tau kev sib txuas lus nrog MS SQL neeg rau zaub mov, yuav tsum xa daim ntawv T-SQL mus rau lub server. Microsoft SQL neeg rau zaub mov tuaj yeem siv los tsim cov duab, kev lag luam thiab lub vev xaib siv database. Nws muab ib puag ncig uas tso cai rau tsim cov ntaub ntawv, uas tuaj yeem nkag mus tau los ntawm chaw ua haujlwm, Is Taws Nem lossis lwm yam xov xwm xws li Personal Digital Assistant (PDA). Thawj version ntawm MS SQL neeg rau zaub mov tau tso tawm xyoo 1989 thiab nws tau hu ua SQL server 1.0. Qhov no tau tsim rau Operating System/2 (OS2). Txij thaum ntawd los muaj ntau qhov kev tso tawm ntawm MS SQL neeg rau zaub mov thiab qhov kev tso tawm tshiab kawg yog SQL Server 2008 R2, uas tau tso tawm rau kev tsim khoom thaum lub Plaub Hlis 21, 2010. MS SQL neeg rau zaub mov kuj tseem muaj nyob rau hauv ntau yam khoom uas suav nrog cov txheej txheem tshwj xeeb rau cov neeg siv sib txawv.
Hais lus, SQL yog ib hom lus hauv computer rau kev tsim thiab tswj kev sib raug zoo databases thiab Microsoft SQL server yog database server uas siv SQL raws li nws cov lus nug tseem ceeb thiab nws tuaj yeem siv los tsim cov ntaub ntawv siv database. Yog li nws pom tseeb tias ob qho no yog qhov sib txawv uas ib qho yog hom lus hauv computer thiab lwm qhov yog siv computer.
