No announcements
Found 2004286 threads
-
2 Votescheck constraints
create table tableA ( colA varchar(50) not null , constraint chk_tableA_colA_alphaNum check (case when ...Answered | 2 Replies | 4657 Views | Created by lucky91 - Wednesday, May 9, 2012 10:21 AM | Last reply by lucky91 - Wednesday, May 9, 2012 1:54 PM
-
0 Votes
EntityFramework problem with SQL TRIGGER
To work with Stored Procedure in EntityFramework, you could take a look at following marterials: How to: define a model with stored ...Answered | 8 Replies | 24464 Views | Created by SuperJB - Friday, August 20, 2010 5:03 PM | Last reply by DA924x - Wednesday, July 4, 2018 12:09 AM -
0 Votes
Unable to create a Check-Constraint in SQL Server 2000
CONSTRAINT pk_YourBaseTable ....Answered | 11 Replies | 2150 Views | Created by Bangaaram - Friday, June 14, 2013 2:02 PM | Last reply by Bangaaram - Friday, June 14, 2013 3:57 PM -
0 Votes
HIDDEN CONSTRAINT
Enabling system-versioning on an existing table for data audit Best Regards, Will MSDN Community ...Answered | 7 Replies | 1246 Views | Created by Sivakumar.In - Monday, May 13, 2019 3:08 PM | Last reply by Sivakumar.In - Tuesday, May 14, 2019 3:54 PM -
0 Votes
Added parens in check constraints
I created new tables with some fields that have check constraints.Answered | 1 Replies | 1414 Views | Created by William Hug - Tuesday, November 6, 2012 6:24 PM | Last reply by Janet Yeilding - Tuesday, November 6, 2012 7:05 PM -
0 Votes
Constraints use
Try this ALTER TABLE <TABLE_NAME> ALTER COLUMN <COLUMN_NAME> INT NOT NULL ALTER TABLE <TABLE_NAME> ADD ...Answered | 1 Replies | 514 Views | Created by Manoj jagdale - Thursday, June 11, 2015 3:38 PM | Last reply by Anuj Tripathi - Thursday, June 11, 2015 3:46 PM -
0 Votes
SmartArt constraints: Evaluation flow
Hi SamH89, do you understand how to use this constraints?Answered | 10 Replies | 6084 Views | Created by SamH89 - Friday, April 20, 2012 12:59 PM | Last reply by Tom Jebo - Wednesday, December 5, 2012 12:49 AM -
0 Votes
Soft Constraints in MP 2007 and 2010
I believe this is what you mean by software constraints.Answered | 4 Replies | 5075 Views | Created by Scheduler OK - Saturday, August 25, 2012 5:38 AM | Last reply by Dale Howard [MVP] - Saturday, August 25, 2012 5:13 PM -
2 Votes
Multiple IDS and Constraint
>And the PK in Files would be a composite of File Id and File Mime.Answered | 5 Replies | 3164 Views | Created by MDMoura - Monday, December 10, 2012 12:59 AM | Last reply by Kalman Toth - Monday, December 10, 2012 12:20 PM -
0 Votes
Foreign Key Constraint even though there's no constraint
>Wouldn't the set identity_insert to on fix this?Answered | 12 Replies | 2522 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 -
0 Votes
Add Constraint for Order.Details (Northwind)
Should you need to do this again, then don't remove any constraint.Answered | 5 Replies | 2895 Views | Created by M.HaWS - Thursday, January 17, 2013 3:14 PM | Last reply by Gert-Jan Strik - Thursday, January 17, 2013 8:51 PM -
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 | 13153 Views | Created by Jonathan Wood - Saturday, October 9, 2010 3:43 AM | Last reply by Jonathan Wood - Sunday, October 10, 2010 3:24 AM -
2 Votes
INSERT statement conflicted with the CHECK constraint
Thanks for the help i disabled the constraint and it worked fine :)))Answered | 4 Replies | 18602 Views | Created by Guddi77 - Wednesday, March 31, 2010 3:30 PM | Last reply by Guddi77 - Thursday, April 1, 2010 6:33 AM -
0 Votes
Swapping Unique Constraint Values
It works for your scenario, but will fail the whole transaciton if it is a real unique constraint violation.Answered | 4 Replies | 10064 Views | Created by Scott Munro - Sunday, October 31, 2010 7:55 PM | Last reply by Alexander Yaremchuk - Monday, August 26, 2013 1:52 PM -
0 Votes
ssis- failure constraint
why not use conditional precedence constraints for this?Answered | 10 Replies | 2125 Views | Created by --_-- - Thursday, March 20, 2014 3:33 PM | Last reply by Visakh16 - Thursday, March 20, 2014 5:44 PM -
0 Votes
recursive relationship constraint
In the nested sets model, a leaf node has the property that the size of the subtree is one, so the constraint I want is (is_atomic (node)) ...Answered | 12 Replies | 4835 Views | Created by gao.seng - Wednesday, March 28, 2012 9:52 PM | Last reply by --CELKO-- - Friday, March 30, 2012 6:37 PM -
0 Votes
Scripting of unnecessary constraints
This tool has a bug in it where it was incorrectly scripting out the constraints.Answered | 4 Replies | 4588 Views | Created by DevTimG - Tuesday, March 9, 2010 9:47 PM | Last reply by DevTimG - Friday, April 2, 2010 3:24 PM -
0 Votes
Type constraints on generic activity
I have a generic activity: public sealed class UpdateEntity<TEntity, TService> : NativeActivity where TService : class, IDisposable where ...Answered | 2 Replies | 4368 Views | Created by MoBill - Friday, January 22, 2010 2:27 PM | Last reply by MoBill - Friday, January 22, 2010 6:11 PM -
2 Votes
SQL Constraint syntax and use
That means that you can not have two constraints with same name.Answered | 2 Replies | 1760 Views | Created by BrockDeanMunro - Friday, April 19, 2013 12:49 PM | Last reply by Marko Frntic - Friday, April 19, 2013 7:49 PM -
0 Votes
Mapping generic function without class constraint to generic function with class constraint
<br/> <br/>Answered | 4 Replies | 3561 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
No announcements
