No announcements
Found 2004362 threads
-
3 VotesADVANCED CHECK CONSTRAINT IN SQL SERVER
You cab create a UNIQUE constraint on col1,col2 in the table.Answered | 3 Replies | 4054 Views | Created by jscompt - Saturday, May 25, 2013 5:55 PM | Last reply by Uri Dimant - Sunday, May 26, 2013 7:04 AM
-
0 Votes
EntityFramework, Version=4.4.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
The following information can be helpful to determine why the assembly 'EntityFramework, Version=4.4.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' could not be loaded. on production ...Answered | 1 Replies | 1973 Views | Created by pragSol - Monday, June 13, 2016 6:28 AM | Last reply by Dave Patrick - Monday, June 13, 2016 12:16 PM -
1 Votes
FK Constraint
The NOT FOR REPLICATION option means that the constraint is enforced on on the publisher.Answered | 2 Replies | 6027 Views | Created by sap9955 - Friday, September 23, 2011 4:14 PM | Last reply by Dan Guzman - Saturday, September 24, 2011 3:13 AM -
0 Votes
Turn Off Constraints Question
I want to turn off the constraints for me, not the end users.Answered | 6 Replies | 4325 Views | Created by Corey Furman - Monday, February 2, 2009 4:33 PM | Last reply by Corey Furman - Monday, February 2, 2009 7:18 PM -
0 Votes
constraint problem
No, you are not creating a constraint, but you are altering a table with 'existed' constraint ALTER TABLE Orders ADD CONSTRAINT ...Answered | 3 Replies | 7426 Views | Created by Manjunath.M - Monday, January 16, 2012 10:41 AM | Last reply by Erland Sommarskog - Monday, January 16, 2012 11:58 AM -
0 Votes
Foreign Key Constraint even though there's no constraint
>Wouldn't the set identity_insert to on fix this?Answered | 12 Replies | 2459 Views | Created by Danny de Haan - Tuesday, April 17, 2012 8:05 AM | Last reply by Danny de Haan - Tuesday, April 17, 2012 8:51 AM -
8 Votes
naming conventions for constraints
For constraints that bear the same name, even though they belong to different schemas, do all of the places were constraint names commonly appear make it clear to ...Answered | 8 Replies | 35540 Views | Created by Knot - Sunday, November 13, 2011 4:11 PM | Last reply by Deepak Munigela - Tuesday, November 15, 2011 1:13 AM -
1 Votes
Advanced Check Constraints
It depends on how clear and reliable I can make my add and delete functions, as to how much time I'll look at CHECK constraints or triggers.Answered | 6 Replies | 13065 Views | Created by Jonathan Wood - Saturday, October 9, 2010 3:43 AM | Last reply by Jonathan Wood - Sunday, October 10, 2010 3:24 AM -
0 Votes
SSIS and check constraints
A similar thing happened when I tried to test a constraint on an integer column, where 3 rows should have been redirected, all of the rows violated the key ...Answered | 6 Replies | 9142 Views | Created by Dan Cambridge - Monday, July 16, 2012 11:32 AM | Last reply by Dan Cambridge - Monday, July 16, 2012 1:17 PM -
4 Votes
Need assistance with Unique constraint
Similarly to unique constraint which creates unique index behind the scenes.Answered | 7 Replies | 2514 Views | Created by SirIndian - Wednesday, December 26, 2012 9:25 AM | Last reply by SirIndian - Thursday, December 27, 2012 10:51 AM -
1 Votes
Build of simple project using EntityFramework failed
Of course, to build it locally I've installed EntityFramework package using NuGet.Answered | 2 Replies | 2555 Views | Created by Paul Kutakov - Tuesday, September 18, 2012 7:40 PM | Last reply by Paul Kutakov - Wednesday, September 19, 2012 7:42 AM -
0 Votes
Disabling all constraints on tables
Secondly, you cannot disable default constraints, you can only disable foreign key constraints and check constraints.Answered | 5 Replies | 2912 Views | Created by warnerrj79 - Friday, December 7, 2012 3:05 PM | Last reply by Chris Sijtsma - Friday, December 7, 2012 7:20 PM -
0 Votes
The primary reference "" could not be resolved because it has an indirect dependency on the assembly EntityFramework with higher version
>>however my original command did work when i removed OutputPath argument OK....Well, so it works fine now.Answered | 4 Replies | 3492 Views | Created by lax4u - Friday, November 6, 2015 9:00 PM | Last reply by Jamles Hez - Tuesday, November 17, 2015 7:34 AM -
0 Votes
Is this expected behavior for an Precendence Constraint that uses an expression?
The question is on your precedence constraints that enter the level 3 task did you change the default of ANDing constraints to ORing, since this is what you want.Answered | 2 Replies | 4345 Views | Created by Bartron2 - Friday, December 19, 2008 2:21 PM | Last reply by Bartron2 - Friday, December 19, 2008 9:24 PM -
0 Votes
Mapping generic function without class constraint to generic function with class constraint
<br/> <br/>Answered | 4 Replies | 3550 Views | Created by Jay Bienvenu (Stuller, Inc.) - Monday, February 28, 2011 4:05 AM | Last reply by Michael Sun [MSFT] - Friday, March 4, 2011 3:19 PM -
2 Votes
Re enable foreign key constraint - CHECK CONSTRAINT vs WITH CHECK CHECK CONSTRAINT
If not specified, WITH CHECK is assumed for new constraints, and WITH NOCHECK is assumed for re-enabled constraints.Answered | 2 Replies | 16850 Views | Created by MGS66 - Thursday, February 10, 2011 2:36 AM | Last reply by TiborK - Thursday, February 10, 2011 8:24 AM -
0 Votes
Unique Constraint
Sure, you can add a constraint providing that you don't already have duplicates in this column.Answered | 4 Replies | 7010 Views | Created by Abdul Hakeem Baloch - Saturday, October 22, 2011 3:17 AM | Last reply by Naomi N - Sunday, October 23, 2011 2:06 PM -
0 Votes
SQL 2008 Default Constraint
In SSMS if you change the "Default Value or Binding" for a column to be 5 it will set the default constraint.Answered | 2 Replies | 6089 Views | Created by Kaly81 - Monday, November 30, 2009 6:19 PM | Last reply by Tome Tanasovski - Monday, November 30, 2009 6:53 PM -
4 Votes
Check Check Constraint
Hi Naomi The only question i have now... do i need to create constraint with nocheck and once the ...Answered | 10 Replies | 5305 Views | Created by VATiger - Tuesday, March 20, 2012 8:19 PM | Last reply by VATiger - Wednesday, March 21, 2012 5:36 PM -
1 Votes
PK and Unique Constraint
Which of these you choose depends on how often you will be joining on this key, and on how big the tables are.Answered | 8 Replies | 1672 Views | Created by MDMoura - Monday, April 29, 2013 11:39 AM | Last reply by Tom Cooper - Monday, April 29, 2013 2:16 PM
No announcements
