<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://sqlserver.ro/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Articole</title><link>http://sqlserver.ro/forums/22/ShowForum.aspx</link><description /><dc:language>en</dc:language><generator>CommunityServer 2.1 SP2 (Build: 61129.1)</generator><item><title>Episodul nr. 3 : "La un pas de dezastru(reloaded)"</title><link>http://sqlserver.ro/forums/thread/98.aspx</link><pubDate>Mon, 18 Sep 2006 07:32:18 GMT</pubDate><guid isPermaLink="false">963f3a18-65dd-4aad-905c-b785cfe1d7c7:98</guid><dc:creator>ggciubuc</dc:creator><slash:comments>0</slash:comments><comments>http://sqlserver.ro/forums/thread/98.aspx</comments><wfw:commentRss>http://sqlserver.ro/forums/commentrss.aspx?SectionID=22&amp;PostID=98</wfw:commentRss><description>&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Din seria “Microsoft SQL Server 2005 in actiune”&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;Astazi episodul nr. 3 :&lt;/P&gt;
&lt;P align=center class=MsoNormal&gt;&lt;SPAN&gt;“La un pas de dezastru(reloaded)”&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;O productie “Admindate &amp;amp; Inf, &lt;SPAN&gt;&lt;A href="http://www.diadmin.ro/"&gt;www.diadmin.ro&lt;/A&gt;” , 2006&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Scenariul si regia Gheorghe Ciubuc&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Personaje principale:&lt;/SPAN&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Alejandro Morientes – DBA in firma “Los capshunares” cu activitati principale in agricultura, undeva in Spania, langa Madrid, anul de gratie 2006.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Pedro Garcia – patronul firmei, 50 de ani .&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Maria-Elena Adochitei – romanca,bunaciunea nr. 1 nascuta la Vaslui, aici printre capsuni.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Miguel Morales – unu din managementul firmei si actionar al ei.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Consuela Cervantes – bunaciunea nr. 2, secretara dl. Pedro Garcia.&lt;/SPAN&gt;&lt;/P&gt;
&lt;DIV class=Section1&gt;Alejandro &amp;nbsp;pe scaun si cu picioarele pe birou, gandind la cat de aproape i-a trecut glontul pe la ureche. Dintr-o data Consuela navali in incapere mai, mai sa sparga usa.&lt;/DIV&gt;
&lt;DIV class=Section1&gt;Consuela Cervantes:”Alejandro…!”&lt;/DIV&gt;
&lt;P class=MsoNormal&gt;Lipsa de stabilitate a scaunului personajului nostru isi spuse cuvantul asa ca Alejandro vazu culoarea neonului de la nivelul solului.&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Alejandro Morientes(masandu-si spinarea)&lt;/SPAN&gt;” Consuela, ce faci mama, era sa-mi rup gatul !”&lt;/P&gt;
&lt;P class=MsoNormal&gt;Consuela:”Alejandro, mi amor…”&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Alejandro&lt;/SPAN&gt;&lt;SPAN&gt;:”Bine ca ai venit&amp;nbsp;, ca uite ma pot gandi la dezastre &amp;nbsp;!”&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;Consuela:”Cum draga , eu sunt un dezastru pentru tine?”&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Alejandro: “Nu, dar il ai pe vino incoa si e de ajuns… Ultima oara cand ai pus mana pe birou ai lansat ceva care mi-a sters niste linii intr-un tabel. Aoleou, dar daca lansai scriptul ala de stergere a unui tabel intreg , ce ma faceam&amp;nbsp;? Ce ma faceam , spune&amp;nbsp;!&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;Consuela:”N-avem alte table atarnate de gard la ferma din spate, le puneai pe alea.&lt;/P&gt;
&lt;P class=MsoNormal&gt;Alejandro:”Ia stai tu binisor la 2 metri de mine pe scaunul ala ca sa gandesc “&lt;/P&gt;
&lt;P class=MsoNormal&gt;Consuela:”Alejandro, mi amor, n-am venit sa gandim ci sa muncim…”&lt;/P&gt;
&lt;P class=MsoNormal&gt;Alejandro:”Lasa-ma un pic.”&lt;/P&gt;
&lt;P class=MsoNormal&gt;Alejandro&lt;SPAN&gt;(gandind cu voce tare)&lt;/SPAN&gt;:”Cred ca o sa folosesc &lt;B&gt;triggere DDL&lt;/B&gt;”&lt;/P&gt;
&lt;P class=MsoNormal&gt;Consuela:”Ce faci ,dai cu DDT ?, cred ca ai furnici la cap !&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Alejandro lua calculatorul in brate si se apuca sa scrie urmatoarele linii de cod pentru baza de date a firmei.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN&gt;CREATE&lt;/SPAN&gt;&lt;SPAN&gt; &lt;SPAN&gt;TRIGGER&lt;/SPAN&gt; Nu_Stergi_Tabele&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;ON&lt;/SPAN&gt;&lt;SPAN&gt; &lt;SPAN&gt;DATABASE&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;-- evenimentul de stergere a unui tabel&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;FOR&lt;/SPAN&gt;&lt;SPAN&gt; DROP_TABLE &lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;AS&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;PRINT&lt;/SPAN&gt;&lt;SPAN&gt; &lt;SPAN&gt;'Nu ai voie sa stergi tabele in baza de date !'&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;--se renunta la stergere&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;ROLLBACK&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;Alejandro:”Gata.”&lt;/P&gt;
&lt;P class=MsoNormal&gt;Consuela:”Gata, esti gata? ”&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Alejandro: “Consuela acum poti sa pui mana unde vrei, ca nu se mai declanseaza nici un dezastru.&amp;nbsp;&lt;/SPAN&gt;”&lt;/P&gt;
&lt;P class=MsoNormal&gt;Consuela:”Alejandro, mi amor, trebuie sa pun mana ca sa vad daca esti sau nu o catastrofa…”&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P align=center class=MsoNormal&gt;&lt;SPAN&gt;SFARSIT&lt;/SPAN&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Regia&amp;nbsp;………………………………………………………………..Ciubuc Gheorghe&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Scenariul(dupa un document Microsoft)……………………………Ciubuc Gheorghe&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;Producator………………………………………………………….. Ciubuc Gheorghe&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P align=center class=MsoNormal&gt;&lt;SPAN&gt;O productie Admindate &amp;amp; Inf, &lt;A href="http://www.diadmin.ro/"&gt;www.diadmin.ro&lt;/A&gt;”&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;</description></item></channel></rss>