No announcements
Found 1245343 threads
-
1 VotesInserting null values and NO values null
Excel source can return null values when text and numbers are mixed in one column.Answered | 1 Replies | 5496 Views | Created by SBolton - Friday, April 16, 2010 8:00 PM | Last reply by Miloslav Peterka - Friday, April 16, 2010 8:49 PM
-
1 Votes
Null values
The default of CASE if no ELSE is specified is ELSE NULL.Answered | 3 Replies | 4124 Views | Created by Khan_K - Tuesday, December 8, 2009 6:52 PM | Last reply by Khan_K - Tuesday, December 8, 2009 7:50 PM -
0 Votes
SelectLists and null values
User-1772813213 posted There should be someway to specify if the list value is being saved to a nullable type and if so a blank option should be placed at the start of the ...Unanswered | 2 Replies | 73 Views | Created by Anonymous - Wednesday, June 25, 2008 11:55 AM | Last reply by Anonymous - Wednesday, August 6, 2008 10:32 AM -
0 Votes
.null. value
You might just want to inner join to not get the result rows with NULL values.Answered | 2 Replies | 2344 Views | Created by Alaa Mukhtar - Friday, April 13, 2012 6:19 PM | Last reply by Olaf Doschke - Friday, April 13, 2012 7:57 PM -
0 Votes
join with null values not returning values
Hello, If you concate a NULL value with an other value it results in a NULL value again.Answered | 2 Replies | 3309 Views | Created by SQLProgramming - Wednesday, July 11, 2012 3:23 AM | Last reply by Olaf Helper - Wednesday, July 11, 2012 3:36 AM -
1 Votes
Inserting null values
Use IsNULL(PlanIND,'R3') in your insert statement this will insert R3 where you have null value.Answered | 2 Replies | 3820 Views | Created by Aaban_M - Wednesday, August 5, 2009 7:19 AM | Last reply by richbrownesq - Wednesday, August 5, 2009 7:21 AM -
0 Votes
null !
Hi as null is not a value it cannot be compared using EQUALS operator.Answered | 1 Replies | 4449 Views | Created by Pasupathi - Thursday, February 21, 2013 10:28 AM | Last reply by Lawrence A. Freeman - Thursday, February 21, 2013 11:23 AM -
0 Votes
Selecting and Null values
When Parameter Value in Table 1 is null I want the Default Value from Table 2 to be displayed.Answered | 9 Replies | 4184 Views | Created by klacy1981 - Tuesday, March 9, 2010 2:24 PM | Last reply by klacy1981 - Tuesday, March 9, 2010 3:48 PM -
5 Votes
Replacing null values
But one thing is the second level values should return NULL between rownumber 10 and 13.Answered | 9 Replies | 5133 Views | Created by Arne Olsson - Tuesday, November 23, 2010 12:15 PM | Last reply by Arne Olsson - Wednesday, November 24, 2010 4:16 PM -
0 Votes
How to check if object value is Null and if null assign NULL to type datetime
So this wouldn't have anything to do with null since a value type cannot be null (ignoring Nullable<T>).Answered | 5 Replies | 10715 Views | Created by NewBInCoding - Wednesday, February 28, 2018 3:09 PM | Last reply by User3DX - Wednesday, February 28, 2018 11:47 PM -
0 Votes
Not able to make column to null value from not null
1)Regardless of the way on how the error is encountered, if a column does not accept NULL values, always assign a value to it when inserting new records to the ...Answered | 3 Replies | 1271 Views | Created by Manthan(Monty) - Wednesday, May 13, 2015 8:09 PM | Last reply by AV111 - Thursday, May 14, 2015 12:43 AM -
0 Votes
Default value if there is null value provided
Hi Yuji, The expressions in Logic Apps should only have the first @ at the beggining, so your expression should ...Answered | 3 Replies | 5094 Views | Created by YNagata - Thursday, March 16, 2017 4:20 AM | Last reply by WSilveiraNZ [MVP] - Monday, April 10, 2017 10:47 AM -
3 Votes
WORKING WITH NULL VALUES
When working with data, which data type would expect to contain NULL values?Answered | 5 Replies | 3669 Views | Created by narang aman - Tuesday, May 25, 2010 5:41 PM | Last reply by KiranKumar.Y - Wednesday, May 26, 2010 12:27 PM -
0 Votes
Getting null values for the attribute
if that is so Some times in any of the month the measure value might be null...Answered | 4 Replies | 5838 Views | Created by Eswararao C - Friday, December 11, 2009 7:02 AM | Last reply by Prasanna K J - Friday, December 11, 2009 10:55 AM -
0 Votes
running value null check
0,"There is Null in here","No Null Present") Good luck.Answered | 4 Replies | 4157 Views | Created by dedbeat - Wednesday, March 4, 2009 8:52 PM | Last reply by Isham H - Wednesday, March 4, 2009 9:40 PM -
2 Votes
NULL values issue
hi If your dealing with NULL value use SET ANSI_NULLS OFF,because sql server treat NULL as unknown value.Answered | 7 Replies | 3239 Views | Created by BI_Support - Monday, July 15, 2013 9:58 AM | Last reply by Satheesh Variath - Wednesday, July 17, 2013 12:07 PM -
0 Votes
NULL values Indexed?
Yes - Null values are included in indexes by default but with new features in SQL 2008 (Sparse columns and filter index) you can change the way it ...Answered | 5 Replies | 5994 Views | Created by myNameIsRon - Friday, April 8, 2011 8:15 PM | Last reply by myNameIsRon - Thursday, April 14, 2011 5:00 AM -
0 Votes
Unique Indexes and NULL values...
That will enforce the constraint to allow multiple NULLs and only unique non-NULL values.Answered | 3 Replies | 4391 Views | Created by JaedenRuiner - Monday, December 7, 2009 3:31 PM | Last reply by Plamen Ratchev - Monday, December 7, 2009 3:37 PM -
1 Votes
can null value be typed other than NULL.
By typed NULL it means a NULL value with a datatype.Answered | 10 Replies | 1198 Views | Created by rajemessage - Thursday, October 13, 2016 1:48 PM | Last reply by Tom Cooper - Thursday, October 13, 2016 6:40 PM -
1 Votes
Update Null Values
If you want to know details about these columns' Null VALUES (PERCENTAGE for example), you can check out this ...Answered | 8 Replies | 1445 Views | Created by BKreft - Monday, November 10, 2014 7:14 PM | Last reply by BKreft - Monday, November 10, 2014 8:25 PM - Items 1 to 20 of 1245343 Next ›
No announcements
