Scribd
Upload
56 views

Basics of SQL Server

Sql handwritten notes

Uploaded by

Wasim Khan
Copyright
© © All Rights Reserved
Available Formats
Download as PDF or read online on Scribd
56 views

Basics of SQL Server

Sql handwritten notes

Uploaded by

Wasim Khan
Copyright
© © All Rights Reserved
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