https://www.dotnetzone.gr:443/cs/forums/28/ShowForum.aspxΘέματα που αφορούν τον SQL Server (7.0, 2000, 2005) αλλά και Oracle, Access, DB2, MySQL, κλπ.elCommunityServer 2.1 SP3 (Build: 20423.1)https://www.dotnetzone.gr:443/cs/forums/thread/60214.aspxThu, 23 Sep 2010 17:39:21 GMT2622095e-976c-431a-859e-16783ec7ecd7:60214Antonios Chatzipavlis0https://www.dotnetzone.gr:443/cs/forums/thread/60214.aspxhttps://www.dotnetzone.gr:443/cs/forums/commentrss.aspx?SectionID=28&PostID=60214<P>να είσαι καλά <img src="http://www.dotnetzone.gr/cs/emoticons/emotion-21.gif" alt="Yes" /></P>https://www.dotnetzone.gr:443/cs/forums/thread/60213.aspxThu, 23 Sep 2010 17:37:13 GMT2622095e-976c-431a-859e-16783ec7ecd7:60213ioagia0https://www.dotnetzone.gr:443/cs/forums/thread/60213.aspxhttps://www.dotnetzone.gr:443/cs/forums/commentrss.aspx?SectionID=28&PostID=60213Χα! Τόσο απλό!<br><br>Σε ευχαριστώ πολύ Αντώνη, δεν θα το έβρησκα ποτέ! <img src="http://www.dotnetzone.gr/cs/emoticons/emotion-2.gif" alt="Big Smile" /><br><br>https://www.dotnetzone.gr:443/cs/forums/thread/60212.aspxThu, 23 Sep 2010 17:35:18 GMT2622095e-976c-431a-859e-16783ec7ecd7:60212Antonios Chatzipavlis0https://www.dotnetzone.gr:443/cs/forums/thread/60212.aspxhttps://www.dotnetzone.gr:443/cs/forums/commentrss.aspx?SectionID=28&PostID=60212<P>πήγαινε Databases&gt;your database&gt;tables&gt;your table&gt;Triggers</P>https://www.dotnetzone.gr:443/cs/forums/thread/60211.aspxThu, 23 Sep 2010 17:30:04 GMT2622095e-976c-431a-859e-16783ec7ecd7:60211ioagia0https://www.dotnetzone.gr:443/cs/forums/thread/60211.aspxhttps://www.dotnetzone.gr:443/cs/forums/commentrss.aspx?SectionID=28&PostID=60211Έχω δημιουργήσει ένα trigger στον ms sql 2005 με την χρήση του παρακάτω κώδικα<br><br><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr style="vertical-align:top;line-height:normal;"><td style="width:40px;text-align:right;"><pre style="font-family:courier new;font-size:11px;color:gray;margin:0px;padding:2px;">1 2 3 4 </pre></td><td><pre style="margin:0px;padding:2px 2px 2px 8px;"><span style="color:Black;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;"><span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">CREATE</span> <span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">TRIGGER</span> test <span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">ON</span> dbo.PARENT <span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">FOR</span> <span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">DELETE</span> <span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">AS</span> <span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">DELETE</span> <span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">FROM</span> CHILD <span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">WHERE</span> CHILD.parentID = (<span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">select</span> id <span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">from</span> deleted)</span></pre></td></tr></table><br>Δεν μπορώ να εντοπίσω που αποθηκεύεται το trigger.<br>To directory Programmability -&gt; Database Triggers είναι άδειο...<br><br><br>Ευχαριστώ!<br>