No announcements
Found 2004236 threads
-
1 VotesPerformance of queries and filters with null values
This makes null essentially free in terms of storage usage, but queries for null work a little differently.Answered | 4 Replies | 1530 Views | Created by Nick M00res - Wednesday, August 12, 2015 10:30 PM | Last reply by Bruce Johnston - MSFT - Thursday, August 13, 2015 5:34 PM
-
0 Votes
SQL NULL value filter query
Please refer more details from below links: isnull vs is nullAnswered | 3 Replies | 1408 Views | Created by kkran - Wednesday, July 15, 2020 5:19 AM | Last reply by Melissa Ma - Wednesday, July 15, 2020 7:04 AM -
0 Votes
Filter null value
[Discount Amount] } ON COLUMNS, NON EMPTY { FILTER(([Product].Answered | 1 Replies | 5490 Views | Created by Gaurav 17 - Wednesday, January 12, 2011 5:57 PM | Last reply by Vinuthan - Wednesday, January 12, 2011 6:38 PM -
0 Votes
query for optional primary key with null value
To do this, click "write code" and select Payment_Inserted.Answered | 1 Replies | 1019 Views | Created by omar_awwad - Thursday, January 31, 2013 10:26 PM | Last reply by Hessc - Friday, February 1, 2013 3:38 AM -
0 Votes
Filtered query values into textboxes on form
So from here you of course pass the values to the generated query GetResults and use the method to pass in the values, that is it.Answered | 3 Replies | 660 Views | Created by NachoShaw - Friday, March 6, 2015 2:13 PM | Last reply by Kareninstructor - Friday, March 6, 2015 3:18 PM -
1 Votes
Assign a Null value to a query
I use a form for filtering a report.Answered | 2 Replies | 559 Views | Created by kvaziri - Wednesday, October 14, 2015 8:44 PM | Last reply by QA Guy CommElec - Wednesday, October 14, 2015 9:25 PM -
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 | 4113 Views | Created by klacy1981 - Tuesday, March 9, 2010 2:24 PM | Last reply by klacy1981 - Tuesday, March 9, 2010 3:48 PM -
0 Votes
Content Query Webpart with PageQueryString filter having null value for selected content types is not returning items in SharePoint online.
I tried to select Document content type but it is not working if I select any content type.Answered | 4 Replies | 1584 Views | Created by Shruti Raturi - Sunday, June 25, 2017 8:47 PM | Last reply by Wendy DZ - Tuesday, June 27, 2017 1:06 AM -
0 Votes
Re Selecting NULL date values in parameters
Hi Aruna, In your scenario, if the result set returned by dataset query doesn’t contain the Null value, when you select the Null ...Answered | 9 Replies | 3227 Views | Created by Aruna2015 - Monday, January 18, 2016 10:52 AM | Last reply by Qiuyun Yu - Tuesday, January 26, 2016 1:34 PM -
1 Votes
Null Value selects All
How do i set the parameter to read null as ALL such as SELECT DISTINCT Name FROM [Ulterra Drilling ...Answered | 6 Replies | 5551 Views | Created by SBolton - Monday, May 16, 2011 4:58 PM | Last reply by Erland Sommarskog - Monday, May 16, 2011 8:59 PM -
0 Votes
select statement for null value
I want to insert value '1' where catagorid is null Regards SumanAnswered | 5 Replies | 6707 Views | Created by Sumanfbc - Sunday, February 27, 2011 11:03 AM | Last reply by Ramakrishna Elashwarapu - Monday, February 28, 2011 7:44 AM -
0 Votes
Filter out integer value = 0 but not NULL
WHERE ColumnInt <> 0 Or ColumnInt is nullAnswered | 2 Replies | 685 Views | Created by rogerwithnell - Monday, March 2, 2015 5:15 PM | Last reply by Patrick Hurst - Monday, March 2, 2015 5:26 PM -
0 Votes
Only inserting valid dates or null values.
Either you have to write some custom logic to filter out invalid date or try to use a derived column to create a new date column using the date values coming from source.Answered | 2 Replies | 4615 Views | Created by jayjayt1988 - Thursday, April 29, 2010 4:09 PM | Last reply by Nitesh Rai - Thursday, April 29, 2010 4:17 PM -
0 Votes
Updating Nulls with select query
Hi I do not think you could combain all SELECTs for single UPDATE...Answered | 4 Replies | 4850 Views | Created by priyapinky - Friday, May 14, 2010 7:25 AM | Last reply by Alex Feng (SQL) - Tuesday, May 18, 2010 2:48 PM -
0 Votes
Include NULL values in GROUP BY selection
create table #t(c varchar(10)) insert into #t values ('1') insert into #t values ...Answered | 5 Replies | 29381 Views | Created by Sam233 - Thursday, April 7, 2011 10:31 AM | Last reply by Uri Dimant - Thursday, April 7, 2011 10:42 AM -
0 Votes
How to query null values
Could you use a parameterized query instead?Answered | 4 Replies | 3036 Views | Created by Stop_the_insanity - Wednesday, February 10, 2010 8:18 PM | Last reply by Stop_the_insanity - Thursday, February 11, 2010 2:19 PM -
0 Votes
how to select null values and restrict '0' values
select * from invoice i where number NOT IN ('0','DEBIT','CREDIT') or number IS NULL Please Mark This As Answer if it solved your issue ...Answered | 2 Replies | 1247 Views | Created by LuckyLucky12 - Thursday, December 10, 2015 11:06 AM | Last reply by Visakh16 - Thursday, December 10, 2015 11:43 AM -
0 Votes
How to set a query filter that sometimes select all
It's nullable, so you could end up with a null value excption, that's why I "recreate" a local version of the parameter value, using GetValueOrDefault ...Answered | 6 Replies | 2732 Views | Created by Billy Kidd - Sunday, July 31, 2011 10:59 AM | Last reply by Yann Duran - Monday, August 1, 2011 12:27 AM -
0 Votes
sql query for null values
If you just want a list of those columns that are not null you can do something like this in ADO.NET (i'm not sure if you're using straight ADO.NET or an ORM or Linq to SQL).Answered | 1 Replies | 3026 Views | Created by niks ds - Saturday, August 20, 2011 6:35 AM | Last reply by Tom_Overton - Sunday, August 21, 2011 11:57 PM -
0 Votes
Interesting results while querying for NULL values and ' ' values
It has a definite value and therefore is not null SELECT * FROM CHECKING WHERE ABC IS NOT ...Answered | 2 Replies | 3803 Views | Created by VamshiKVK - Tuesday, October 25, 2011 2:19 PM | Last reply by VamshiKVK - Wednesday, October 26, 2011 5:57 PM - Items 1 to 20 of 2004236 Next ›
No announcements
