http://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/6959.aspxWed, 25 Mar 2009 15:58:53 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6959rsocol0http://sqlserver.ro/forums/thread/6959.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6959<P>Nu uita ca atunci când termini să-i dai:</P> <P><SPAN style="TEXT-ALIGN:left;WIDOWS:2;TEXT-TRANSFORM:none;TEXT-INDENT:0px;BORDER-COLLAPSE:separate;FONT:11px 'Courier New';WHITE-SPACE:normal;ORPHANS:2;LETTER-SPACING:normal;WORD-SPACING:0px;-webkit-border-horizontal-spacing:0px;-webkit-border-vertical-spacing:0px;-webkit-text-decorations-in-effect:none;-webkit-text-size-adjust:auto;-webkit-text-stroke-width:0;" class=Apple-style-span><SPAN style="BACKGROUND-COLOR:transparent;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:11px;FONT-WEIGHT:normal;">exec</SPAN><SPAN class=Apple-converted-space>&nbsp;</SPAN>sp_MSforeachtable<SPAN class=Apple-converted-space>&nbsp;</SPAN><SPAN style="BACKGROUND-COLOR:transparent;FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:11px;FONT-WEIGHT:normal;">'ALTER TABLE ? <U>WITH CHECK</U> CHECK CONSTRAINT ALL'</SPAN><SPAN class=Apple-converted-space>&nbsp;</SPAN></SPAN></P> <P><FONT face=Tahoma><SPAN style="TEXT-ALIGN:left;WIDOWS:2;TEXT-TRANSFORM:none;TEXT-INDENT:0px;BORDER-COLLAPSE:separate;FONT:11px 'Courier New';WHITE-SPACE:normal;ORPHANS:2;LETTER-SPACING:normal;WORD-SPACING:0px;-webkit-border-horizontal-spacing:0px;-webkit-border-vertical-spacing:0px;-webkit-text-decorations-in-effect:none;-webkit-text-size-adjust:auto;-webkit-text-stroke-width:0;" class=Apple-style-span><SPAN class=Apple-converted-space></SPAN></SPAN><SPAN style="TEXT-ALIGN:left;WIDOWS:2;TEXT-TRANSFORM:none;TEXT-INDENT:0px;BORDER-COLLAPSE:separate;FONT:11px 'Courier New';WHITE-SPACE:normal;ORPHANS:2;LETTER-SPACING:normal;WORD-SPACING:0px;-webkit-border-horizontal-spacing:0px;-webkit-border-vertical-spacing:0px;-webkit-text-decorations-in-effect:none;-webkit-text-size-adjust:auto;-webkit-text-stroke-width:0;" class=Apple-style-span><SPAN class=Apple-converted-space><FONT size=2 face=Tahoma>Clauza WITH CHECK este utilă pentru a face constraint-urile să fie din nou&nbsp;"trusted".</FONT></SPAN></SPAN></FONT></P> <P><FONT face=Tahoma><SPAN style="TEXT-ALIGN:left;WIDOWS:2;TEXT-TRANSFORM:none;TEXT-INDENT:0px;BORDER-COLLAPSE:separate;FONT:11px 'Courier New';WHITE-SPACE:normal;ORPHANS:2;LETTER-SPACING:normal;WORD-SPACING:0px;-webkit-border-horizontal-spacing:0px;-webkit-border-vertical-spacing:0px;-webkit-text-decorations-in-effect:none;-webkit-text-size-adjust:auto;-webkit-text-stroke-width:0;" class=Apple-style-span><SPAN class=Apple-converted-space><FONT size=2 face=Tahoma>Răzvan</FONT></P></SPAN></SPAN></FONT>http://sqlserver.ro/forums/thread/6958.aspxWed, 25 Mar 2009 15:18:44 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6958xmldeveloper0http://sqlserver.ro/forums/thread/6958.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6958Se poate face cu un cursor (folosind numele tabelelor) sau daca este vorba de SQL Server 2000 folosind urmatorul cod:<br><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;">exec</span> sp_MSforeachtable <span style="color:Red;background-color:transparent;font-family:Courier New;font-size:11px;font-weight:normal;">'ALTER TABLE ? NOCHECK CONSTRAINT ALL'</span> </span><br>http://sqlserver.ro/forums/thread/6957.aspxWed, 25 Mar 2009 15:09:21 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6957cioby2k0http://sqlserver.ro/forums/thread/6957.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6957salut.<br>incerc sa copiez datele de pe o baza pe alta si nu stiu in ce ordine trebuie copiate tabelele. de aceea caut o metoda pentru a dezactiva foreign key-urile temporar, pentru cat inserez datele in tabela. aveti vreo idee cum se face?<br>