No announcements
Found 333 threads
-
0 Voteshow to check the situation of "unique key duplicated" or "not null" in ConstraintException
hi I'd like to ask a question. I have a Dataset and in the Dataset there are contraint for "not null" in ...Answered | 2 Replies | 802 Views | Created by martinwang1985 - Thursday, April 2, 2015 1:44 PM | Last reply by martinwang1985 - Friday, April 3, 2015 9:31 AM
-
0 Votes
Not Null
I need to find all the columns from all tables that have NOT NULL constaint of my database. Is there any script? Thanks in advance...Answered | 3 Replies | 2335 Views | Created by KP_SQL - Friday, August 3, 2012 3:33 PM | Last reply by shriprasanna - Friday, August 3, 2012 3:54 PM -
2 Votes
Bug in Not Null?
I suspect it is not null instead 'NULL' is written in these columns as text. Can you try this: select LEN( Grade ) Grade_Len, * fromAnswered | 6 Replies | 405 Views | Created by AlHoward - Monday, February 22, 2016 3:42 PM | Last reply by --CELKO-- - Monday, February 22, 2016 9:20 PM -
1 Votes
Check for not null values
; }; I want to set 'Location' value with som default value(say "NoLocation') if the table does ...Answered | 1 Replies | 1587 Views | Created by Shanthi dhanus - Tuesday, July 16, 2013 8:51 AM | Last reply by Michael Samteladze - Tuesday, July 16, 2013 9:36 AM -
0 Votes
Varchar(n) not null and ReadXML ConstraintException
R2) in which is a varchar(255) NOT NULL column. Usinf SQL, I've generated the schema and XML using for xml, auto, xmlschema in my query. Some rows in the table have a zero length ...Answered | 3 Replies | 2351 Views | Created by CraigZ - Thursday, November 15, 2012 4:36 PM | Last reply by CraigZ - Friday, November 16, 2012 10:43 AM -
0 Votes
StructuralComparisons.StructuralEqualityComparer returning not null
Right now static checker complains about if StructuralComparisons.StructuralEqualityComparer returns a null. However it doesn't. Please add the necessary ... -
0 Votes
NOT NULL Doldrums :(
If your table already has some NULL values in the column you'll need to issue an update statement before setting the column to NOT NULL.Answered | 2 Replies | 4872 Views | Created by sid81 - Monday, July 14, 2008 12:01 PM | Last reply by richbrownesq - Monday, July 14, 2008 12:28 PM -
2 Votes
Selecting not null columns
DOH! Feeling dumb right now. I've been in the Oracle world for awhile and was thrown this project recently. You are right, they are literal NULLs, ...Answered | 3 Replies | 1869 Views | Created by ms87714 - Thursday, September 20, 2012 4:03 PM | Last reply by ms87714 - Thursday, September 20, 2012 4:13 PM -
2 Votes
NOT NULL Constraint
NOT NULL constraint protect to accept null values . The not null constraints are used to enforce domain integrity like the check ...Answered | 7 Replies | 1380 Views | Created by Caladiya - Thursday, August 14, 2014 1:08 PM | Last reply by Ahsan Kabir - Thursday, August 14, 2014 8:23 PM -
0 Votes
Validating not null values
[Column(Storage="_Name", DbType="NVarChar(30) NOT NULL", CanBeNull=false, UpdateCheck=UpdateCheck.Never)]Answered | 4 Replies | 4345 Views | Created by Wiktor Kozlik - Saturday, August 25, 2007 6:55 PM | Last reply by WilliamStacey - Wednesday, August 29, 2007 11:25 PM -
0 Votes
Selecting not null values
(column1,column2,column3,column4,column5) is not null; Below one is very similar logic .Answered | 7 Replies | 4278 Views | Created by mr4100 - Friday, September 19, 2008 1:13 PM | Last reply by mr4100 - Friday, September 19, 2008 1:49 PM -
0 Votes
not null constraint
ALTER TABLE MyTable WITH NOCHECK ADD CONSTRAINT MyColumn_NOTNULL CHECK (EmployeeName IS NOT NULL)Answered | 3 Replies | 3884 Views | Created by bharathi_m - Wednesday, March 10, 2010 10:20 AM | Last reply by Manigandan A - Wednesday, March 10, 2010 11:49 AM -
0 Votes
Textbox not null
How can I build an if statement that would set focus to a textbox that is null or has no value? if (textbox1.text = ...Discussion | 2 Replies | 1348 Views | Created by Lithuanian98 - Tuesday, April 10, 2012 3:07 AM | Last reply by Lithuanian98 - Tuesday, April 10, 2012 3:51 AM -
0 Votes
checking for not null
I tried using a conditonal but keep getting a boolean error. If it is not null i want to give it the value 36 else ignore ...Answered | 6 Replies | 5372 Views | Created by mr4100 - Tuesday, April 1, 2008 2:26 PM | Last reply by mr4100 - Friday, April 4, 2008 2:05 PM -
5 Votes
NOT NULL constraint
WHEN I TRY IT USING THIS STEP, I AM TRYING TO SHOW HOW TO ADD COLUMN AND DELETE IT IF OBJECT_ID(N'dbo.Robust2', N'U') IS NOT NULL drop ...Answered | 7 Replies | 730 Views | Created by I4QR1A - Wednesday, November 26, 2014 2:09 PM | Last reply by Prashanth Jayaram - Wednesday, November 26, 2014 3:07 PM -
3 Votes
Not null constraint
carries very little cost (probably no or little data access). Something like (test NOT NULL vs CHECK constraint with 3 mill rows): --Run twice to allow for ...Answered | 16 Replies | 5381 Views | Created by Ashru - Wednesday, April 29, 2009 7:07 AM | Last reply by Brian Tkatch - Wednesday, April 29, 2009 5:39 PM -
0 Votes
Not Null Date Default
if I communicate that there are no null fields in the data, but for dates it often becomes an issue. Is there a industry standard approach to managing "empty dates" ...Answered | 2 Replies | 5709 Views | Created by Toyist - Monday, August 30, 2010 3:41 PM | Last reply by Toyist - Tuesday, August 31, 2010 2:29 PM -
0 Votes
if is not null
I could not get my VBA to work with is not null, so I did a len statement instead (But that is also not working) If the field is not null ...Answered | 1 Replies | 428 Views | Created by Mark Matzke - Tuesday, December 30, 2014 6:48 PM | Last reply by Mark Matzke - Tuesday, December 30, 2014 7:00 PM -
4 Votes
IS NOT NULL and OR
I don't want the results for C1 to include any NULL values or 'Pass' values. Mr Shaw The predicate "C1 <> 'Pass'" ...Answered | 9 Replies | 2219 Views | Created by Mr Shaw - Tuesday, January 22, 2013 6:22 PM | Last reply by CountryStyle - Wednesday, January 23, 2013 10:13 PM -
0 Votes
Columns [not null]
hi, I have a problem with a flat file and a table I have a flat file with 5 columns and in the table I have 30 columns and they all are (not null) I ...Unanswered | 3 Replies | 4979 Views | Created by PastillaReturn - Sunday, October 15, 2006 3:27 AM | Last reply by TheViewMaster - Sunday, October 15, 2006 4:06 AM - Items 1 to 20 of 333 Next ›
No announcements
