Coob leej ntawm peb tau siv thiab ua haujlwm nrog Databases ib txoj kev lossis lwm qhov. Feem ntau lub sijhawm, thaum DBA lossis Tus Txheej Txheem Database, tsis muaj nyob hauv cov tuam txhab, tom qab ntawd nws yog rau koj kom koj txhais tes qias neeg los ntawm kev sau SQL Cov Lus. Qhov kev qhia no, yuav taug kev koj los ntawm kev sau SQL Cov Nqe Lus hauv kev khaws thiab tswj cov ntaub ntawv. Peb yuav tsum saib 4 thaj chaw tseem ceeb
1) SELECT - Cov lus txib no yog siv los khaws cov ntaub ntawv los ntawm lub rooj
2) INSERT - Cov lus txib no yog siv los ntxiv cov ntaub ntawv rau lub rooj
3) Hloov kho tshiab - Cov lus txib no yog siv los hloov cov ntaub ntawv rau lub rooj
4) DELETE - Cov lus txib no yog siv los tshem cov ntaub ntawv los ntawm lub rooj
Cov kauj ruam
Kauj Ruam 1. Nyem rau Pib Txhua Yam Haujlwm Microsoft SQL Server (2005/2008) SQL Server Management Studio
Kauj Ruam 2. Tom ntej ID nkag mus nrog koj daim ntawv pov thawj rau Server
Kauj Ruam 3. Tam sim no nyem rau ntawm Northwind Database thiab xaiv Cov Lus Nug Tshiab
Kauj Ruam 4. Hauv qhov Query Window tshiab, sau cov lus txib hauv qab no rau SELECT
Kauj Ruam 5. Nov yog cov syntax rau SELECT - SELECT * FROM Cov Neeg Ua Haujlwm
Kauj Ruam 6. Nov yog cov syntax rau INSERT -
INSERT INTO Cov Neeg Ua Haujlwm VALUES ('col1', 'col2') - Hloov col1 thiab col2 nrog qhov tseeb tiag raws li qhia hauv qab no
INSERT INTO Cov neeg ua haujlwm qhov tseem ceeb ('Anil', '[email protected]')
Qhov no ntxig ib kab rau hauv lub rooj.
Txawm tias koj xav nkag mus rau ntau kab ntawm ib zaug, koj pom cov lus txib hauv qab no
INSERT INTO Cov neeg ua haujlwm qhov tseem ceeb ('Anna', '[email protected]'), INSERT INTO Cov Neeg Ua Haujlwm qhov tseem ceeb ('Krystel', '[email protected]'), INSERT INTO Cov neeg ua haujlwm qhov tseem ceeb ('Kab', 'kab@tuam txhab. cov '). Qhov sib txawv tseem ceeb ntawm no yog tias txhua tus nqi txuas ntxiv los ntawm a comma
Kauj ruam 7.
Nov yog cov syntax rau Hloov Kho - Hloov Kho Cov Neeg Ua Haujlwm SET col1 = 'tus nqi tshiab' LEEJ TWG col1 = 'tus nqi qub' - Hloov col1 nrog qhov muaj txiaj ntsig tiag raws li qhia hauv qab no
Hloov kho Cov Neeg Ua Haujlwm SET Lub Npe = 'Anil Mahadev' Lub Npe Lub Npe = 'Anil'
Nov yog cov syntax rau DELETE - DELETE FROM Cov Neeg Ua Haujlwm nyob qhov twg col1 = 'tus nqi' Qhov twg tus nqi = 'cov ntaub ntawv tseeb'
DELETE FROM Cov Neeg Ua Haujlwm QHOV TSEEB Lub Npe = 'Anil Mahadev'
Qhov no ua tiav qhov luv-How-To, Kuv vam tias qhov no tau muaj txiaj ntsig zoo rau koj thiab nyiam Ua tsaug rau koj saib nws.
Lub tswv yim
- Siv SQL Server Management Studio Code Snippets ua cov lus qhia kom zoo dua koj li SQL Kev Txawj Sau Ntawv
- Raws li koj dhau los yooj yim sau Cov Lus Nug, Siv SQL Query Designer los tsim cov lus nug ntse
Lus ceeb toom
- Tsis txhob siv DELETE yam tsis muaj QHOV QAB nyob hauv koj Cov Lus los tiv thaiv kev raug rho tawm ntawm kab
- Tib txoj cai siv rau Hloov tshiab thiab INSERT ib yam
- Ib txwm siv Ceev faj thaum ua haujlwm nrog DELETE hais kom ua.
