Scribd
Upload
104 views9 pages

Basics of SQL Server

Sql handwritten notes

Uploaded by

Wasim Khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
104 views9 pages

Basics of SQL Server

Sql handwritten notes

Uploaded by

Wasim Khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
You are on page 1/ 9
1) S@L_C Stuctused Query Language ) | F SQL 8 Sal isa non proced vacal. lang uoge. Which was inboducd by the TBP aaa hich is used do Communicate tith database | ee eee ee | al Sa. Greate. _ | aInseat Update Epellore s 7 aaa | ee Ee oecle cy : 4) is also Gliled_as Ssequeal_o€ CLI lomguage.t nex henguage, Sntenfoce). This is only | the language “rabtch Can use de Communigie. with ony RD&AMS pooduct. 7 z eee =) d | eee een ES fsa) Senex » AS = Ne ____ predoct CCon | G@L is not _Case Sensitive lomguage tho} 12. Gn oxide SQL predefined quesies ox Symdtonee in_any Cose._characteris.C either: Upper _orx oie ® Cyeay Sat Statement should ends oith 1 micolen—but It is _optenal in sal ae lene blanguades Of Ss@t ta DeRnaton han guage. CDpED © Greate Alten Sp_.Remame. - * Jaum Core. . Dapp , sae Atel ae Dota Man upulakion longue cores Seamer Tt Be Z upDate Bred (5 le - Delete ne een q Duean lamguoge etn Select as 1DON SC ais language Pas ae ete! Mens pat * RolEPiagie Bt io jiae 7 z Sovepoindt 2) Gi: CE : Dota — ea Language £0el) - 9 | Gramma 5 1 ais © Renioke.. «sit site ODPL Chota DeAnatten language) — . gS —eee . so “this Llonguoge Commands ore using to define , | Modify 4 Dav p_on object _0& dotabase from —_ SQ@l_ semen. ® Caeale 8- Creating o new dotabose ox re. table. in S@L_ Seaverr — C aid - Geote_o news dotobase in SQ) Servec _ —Silepi -Syntox $= Create dotobase ae _Slep2 See ieet sequined dotabase. Bom ei —__S@l Sewers. _ ie 2 Ps = ayia $- Use < DB Nomey: a hoiaee 4 9 eee eae UGS | ARNIS sis ai eee Step 4 '- Corcate new table in data bose - —Syntor &- Create +toble. ¢Tohle Nome Seem —_CGlumnaNamor> Usi2e., £Ceturen No: Ge tee 1996 Glurmns Wes 2 (Creel mole. Stucdemt+_ Csi-mary 2 '—Smame._chore C1od 5 Sfee Decimal C, "AGE Tmyint 5 —Sieps 1- “tn Sel dhe tects mega a Syntace = epee Elp £Table Nome ys oS . Ex $= _Sp-HELp Shudernt ; =e ae @ | HELP is 5 pacdefined. Steamed | pests procdinc. : TER it eel chonge. of. 1 ened ify: ee ea | co tables om di detabase 4 + i ny using the Alters Ceramand 1 De Gin penefienn | following ce OpercationS _en_eaishn perrfodan these. Operations We megui supcommands of alten. Sid bate i> Alten = Alters Colum Wd Altea: Adal dock sional aie eel | iia Sp - Rename Dads! Sersih ce Keer abtgall H i> Co serene one) "ee ae ) Allen - Altece Calurnn 12a chonge dope | ; Syntow eed il f Attes toble Zn Alten Coluinn. Ee GalientiNeme eh F (new dT> [New sizod: | 7 i —— ; Bo: A tere dble- Shalont. Alle. C Coluron SNarabe Noah ore C6605 page 3. aS ek lip Ales a Pcisting sdcillenee aie rae Syntax s— Altea dable. “Zand App LNee we Nome > ZDT2Csize7s ees reer ote vege iii? Sp- Remome. 2= To change —O ~_ oa doable name. in_ dotabase:________4 “AD Syntac.4o chonge G Column Home jn table; __Sp_ Remame.. 2 Table. NameD cL Gollgessai ate ESPN no Calum Nome 2 BD Gyntex de change..6 tabla foxna. Baw eo To omp 2= Daopping 0 tuble. fiema dotabose | aolueia fore oll ‘Column's indo Syndaae. = Tns. We ill Spuchiwe of the table. by Using tamaste. 4 mond We Gm not delete a specific mow | fore the table, because, tt desert auppast « Wheare.” Clouse Condition - bob, ie Lei 8oie en mreete Siuiel Colle Names Un ce 2- TTamcate. toble Studem+ i oye ee _peamanotly f 2 y _ Syntace! - Dapp table _¢ Table. Namo75 _ eae Dowp table. Tehid eve 5 ae See OD rm [ke ala Pomupelakon. Language) 1 el aie language —Grnmend6 ae used er rn Ch oon geno sieabaal pulatte. dato in _database.table- 1) “ImSead- $= TImserting A net opto in be a 4a ple 4 Thea. Ore 400 methods do insext- pices sting oul Le doable. CoAbouk ory ec ome 0 ae all i rai Dibdn) Zaablesame> Soles C Nolet pNalun2 9 Rei a al, wie er ee dabble. Student Cstrp int sg: : Naxchoer_CH°) » sfee decimal C6s2)-5 dings. +5 che. 2 + Bacchi. Sc be GN Spe AT es ae op ee smsert jnto Shidemt valuos Clol, “SAT * 2600, 91) = eee é — OR Loe plage ds siete insert Sthdemt Voluos (loos “TAMES ? AGOm 5 99 Diccal che a) tee i) Ecpli dt og ES Palys —fox_eequitecl_Gluran's only Cott —Geluran tin Ale. table) 9) 4a ee Syntax — 2 i OR Es Sl de ieee 3 Insert [INTO ¢TableNamo> C i —_Glumn NomoS > Vajues Clea © ALLEN? )_ Hots +p —S0See 1 Multiple on sto a tob —Syntox. fix impli 84 = Ga. Insert [INTO < tablen ame.> NaluaS C Rows -—Moluo S) 5 CPow2 voluas) - aa _TInsext ind Le IOG. yWlolo > te Bidet Volues (Io ae Heals. +“borrcl?, tooo, -Siyaon foe eria tee | Insert [THTO) | aa |LTohletamo S| C Ren a Names) Values (Rew! Values) pip. a i @ Ee Ansest shidemt C¢Srrp> values Clo6>, C107 Glo 8D. @ opdate s— Updating all aus data ino ___ | Ana ota tme of a Specific a0) deta ima toble. by Using ¢hhene.” Conditon , Syntace, eae update._< Table. Name > Sep v2 Golub erene 42 “= QNoluc LP, £ColumnnName2 > 2 ==) GB Whepe) Codibtom ise 2 2 So al Gute etter gucrny 4p update. employ ezjols eis} HR, Saloay aS 1. 000 _® WhoS employee _—_— Numben Iso97 223 ee pee ie update_em Bet! Jobi= ¢HR?%y Salacy =|4000_4 ae = FIRB sata op epee a8 Kei- alee as query wh paste. “alt epg a __ Coramition— Oe neo Lee 66 - a updore. eT Set Comm = 500 — ® Pelee 2 “Deleding all umes fpr dae oi doable ot a es Ge Specife and _ fron af _ths table by Using wohere._Clause Gmdikon * z Ste fo £tanlaowe?-t Eihee forondh ® 2 ermploye2. fim, Je agua) 2m adelete. PIO ea. periaae Ec:-_bebte a Query — : in dhe. Job feM the table. whe eer Working te i i a

You might also like