No announcements
Found 435777 threads
-
0 Votes
handlling null
User-2083102135 posted Hi in the following line txtEmail.Text = recset1.Item("Email") error ...Answered | 1 Replies | 30 Views | Created by Anonymous - Thursday, May 29, 2008 7:48 PM | Last reply by Anonymous - Thursday, May 29, 2008 9:39 PM -
0 Votes
how to handlle excel file source with .xlsx extension
Hi.. I have 2010 excel file as source , when i am trying to take that as source, its giving error. What are the properties i need to change in ssis package ...Answered | 2 Replies | 4454 Views | Created by Daniel256 - Friday, June 10, 2011 1:03 PM | Last reply by DeepakKumarKalyanum - Monday, June 13, 2011 2:42 PM -
1 Votes
a == null vs null == a
Hi, In C++, if(a = null) is a semantic error but if(null = a) is a compile time error.Answered | 5 Replies | 4926 Views | Created by Sri Harsha - Thursday, November 18, 2010 11:46 AM | Last reply by Louis.fr - Thursday, November 18, 2010 11:20 PM -
2 Votes
NULL = ?
They allow optimizing storage for NULLs.Answered | 14 Replies | 4548 Views | Created by Simply Sql - Wednesday, December 23, 2009 2:54 PM | Last reply by Hugo Kornelis - Wednesday, December 23, 2009 4:24 PM -
2 Votes
Null
This will update the column with its own value if it is not null.Answered | 4 Replies | 5606 Views | Created by Muhammad Bilal - Tuesday, January 11, 2011 6:03 PM | Last reply by Bipin. P - Tuesday, January 11, 2011 6:08 PM -
0 Votes
MDX question: (null) is not null
Hi Iammac, The check for null in mdx is not the same as sql and a null value will equal zero in the boolean test.Answered | 1 Replies | 7055 Views | Created by iammac - Wednesday, September 28, 2011 6:03 AM | Last reply by Paul te Braak - Wednesday, September 28, 2011 9:52 AM -
1 Votes
Query to Differentiate null and not null
Select Distinct Min(t.dcode), t.enbr, Min(t.sname), Stuff((Select ',' + Cast(ucode As varchar(11)) From @tab t2 Where t.enbr = ...Answered | 2 Replies | 2864 Views | Created by Muhammad Bilal - Friday, November 18, 2011 9:27 PM | Last reply by Tom Cooper - Friday, November 18, 2011 9:57 PM -
4 Votes
IS NOT NULL and OR
When you say c1<>'pass' nulls are excluded because nulls are unknowns and sql will not return the unknowns.Answered | 9 Replies | 2475 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
INSERT INTO Null or Not Null Dates
If I test for the date being Null and use the NULL value and it the date exists then have an other statement with ##, this is fine and how I actually have the code.Answered | 10 Replies | 974 Views | Created by BrianSir - Friday, November 20, 2015 7:08 PM | Last reply by Alphonse G - Saturday, November 28, 2015 1:16 AM -
0 Votes
Why use NULL and NOT NULL
There is a lot of debate about using NULL values.Answered | 1 Replies | 9709 Views | Created by Bruce One - Friday, November 10, 2006 12:15 PM | Last reply by Buck Woody - MSFT - Friday, November 10, 2006 2:51 PM -
0 Votes
Difference - @var is null , @var = null
in simple way to remind if you want to set NULL value into variable use equal sign, while in condition use IS ...Answered | 4 Replies | 1089 Views | Created by HarSan Online - Friday, May 29, 2015 3:20 PM | Last reply by HarSan Online - Friday, May 29, 2015 4:12 PM -
2 Votes
Null!
= null) _ProgressBar.Value = _Player.GetHP; }Answered | 3 Replies | 710 Views | Created by Joshua1987 - Wednesday, May 14, 2014 2:45 AM | Last reply by Joshua1987 - Wednesday, May 14, 2014 2:11 PM -
4 Votes
to be NULL or NOT NULL is here the question
Column Null Ratio Profile Reports the percentage of null values in the selected column.Answered | 8 Replies | 1092 Views | Created by Bjorn D. Jensen - Sunday, August 24, 2014 8:48 AM | Last reply by Bjorn D. Jensen - Thursday, September 11, 2014 10:44 AM -
10 Votes
how to check sqldatareader is null or not null
= DbNull.Value) //if value in columnA is not null { //.... } } //or if reading a column if more rows: stirng query = "SELECT ColumnA FROM ...Answered | 4 Replies | 57453 Views | Created by miruan - Wednesday, August 22, 2012 12:24 PM | Last reply by Mitja Bonca - Wednesday, August 22, 2012 2:14 PM -
1 Votes
Inserting null values and NO values null
Excel source can return null values when text and numbers are mixed in one column.Answered | 1 Replies | 5406 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
how to join null with null value
Actaully My joi like this prov.Client=wfb.Client in that Prov.cleint is null also wfb.client is null and ...Answered | 1 Replies | 2434 Views | Created by Aminesh - Friday, November 18, 2011 5:35 AM | Last reply by Hasham Niaz - Friday, November 18, 2011 5:40 AM -
1 Votes
Casting Nulls to Null Types Justification
My question being if the OleDbCommand.ExecuteReader() function fails, does it assign an OleDbDataReader varible\object as null or (OleDbDataReader)null ...Answered | 2 Replies | 2563 Views | Created by nj-c - Friday, March 26, 2010 3:51 AM | Last reply by nj-c - Friday, March 26, 2010 10:50 PM -
0 Votes
is not null
How do you display a value if it is not null?Answered | 1 Replies | 3269 Views | Created by Tessa75 - Sunday, June 3, 2012 2:50 PM | Last reply by ArthurZ - Sunday, June 3, 2012 9:36 PM -
0 Votes
How to check if object value is Null and if null assign NULL to type datetime
= null ?Answered | 5 Replies | 10455 Views | Created by NewBInCoding - Wednesday, February 28, 2018 3:09 PM | Last reply by User3DX - Wednesday, February 28, 2018 11:47 PM -
0 Votes
How are Null Values Compared in SCD.
Without this information, one might get a feeling as NULL = NULL in SCD :-) Regards, RajuAnswered | 5 Replies | 5305 Views | Created by Jagapathi Raju - Monday, September 28, 2009 6:00 AM | Last reply by Duane Douglas - Tuesday, September 29, 2009 4:20 AM - Items 1 to 20 of 435777 Next ›
No announcements