No announcements
Found 1736409 threads
-
0 VotesLinq FromSqlRaw - Data is Null. - Comments Field Varchar Null
User475983607 posted How to resolved this in FromSqlRaw?Answered | 1 Replies | 1550 Views | Created by Anonymous - Thursday, March 11, 2021 5:01 PM | Last reply by Anonymous - Thursday, March 11, 2021 6:38 PM
-
0 Votes
Storage space used by null/blank VARCHAR fields?
The storage size is the actual length of the data entered + 2 bytes If there is no data (empty), then the minimum storage ...Answered | 2 Replies | 2727 Views | Created by cbassett82 - Monday, March 27, 2017 9:30 PM | Last reply by Olaf Helper - Tuesday, March 28, 2017 5:50 AM -
0 Votes
Use of IS NOT NULL in LINQ
Hi Soumyasu, Below is an analogous post on how to use nullable value in LINQ, if you still can not resolve your issue, I recomment that you can post your ...Answered | 2 Replies | 4216 Views | Created by soumyasu - Tuesday, October 27, 2009 10:06 AM | Last reply by Jim Zhou - MSFT - Friday, October 30, 2009 10:02 AM -
1 Votes
About Empty , Null and Not Null fields in database
I am trying to find out, memory allocation for empty "" field only.Answered | 6 Replies | 2014 Views | Created by The_ITQC - Friday, December 14, 2012 6:28 PM | Last reply by Mark Liu-lxf - Monday, December 31, 2012 6:33 AM -
0 Votes
null in linq
This type of error occurred when you should work with singleton collection in linq query.Answered | 7 Replies | 11348 Views | Created by H.Aftabi - Wednesday, June 30, 2010 9:18 AM | Last reply by pka246 - Monday, September 21, 2015 8:49 AM -
1 Votes
varchar data type allocates disk space if it is NULL
So null values typically use 2 bytes.Answered | 2 Replies | 6826 Views | Created by George Zhou - Tuesday, January 17, 2012 7:11 PM | Last reply by Dmitri Korotkevitch - Tuesday, January 17, 2012 7:54 PM -
0 Votes
Null objects and LINQ?
If a null property on your criteria object indicates that field should be ignored: IEnumerable<Person> matches = personList.Where(person => ...Answered | 2 Replies | 1228 Views | Created by Cryo75 - Thursday, October 18, 2012 5:33 AM | Last reply by John Michael Bird - Thursday, October 18, 2012 7:13 AM -
4 Votes
Resizing Column from VARBINARY to VARCHAR in Big Table (No Data in it-all Nulls)
If you alter the existing column, SQL Server wil need to scan the entire table in case you have non-null values that need to be converted to varchar.Answered | 3 Replies | 2798 Views | Created by Sonic.Jessy - Monday, August 13, 2012 10:00 PM | Last reply by Sonic.Jessy - Tuesday, August 14, 2012 4:12 PM -
2 Votes
inserting into a not null field
For existing data update use below statement, update t2 set AdminComment = 'N/A' where AdminComment is null And to avoid further null updates to ...Answered | 7 Replies | 1320 Views | Created by QEDDave - Thursday, April 10, 2014 4:38 PM | Last reply by Shenoy P - Tuesday, April 15, 2014 7:25 AM -
0 Votes
What is the meaning of Varchar(max) = Null in SQL Server 2005 ?
Hi there, varchar(max) is a new data type introduced from Sql Server 2005 only.Answered | 3 Replies | 8833 Views | Created by SSRS New Bie Beginner - Saturday, May 1, 2010 7:41 PM | Last reply by KiranKumar.Y - Monday, May 3, 2010 11:13 AM -
0 Votes
Null object reference in Linq
If they were large collections I would probably use a stored procedure and call that in my linq statement.Answered | 9 Replies | 6963 Views | Created by Jerry Lanp - Saturday, May 29, 2010 8:55 PM | Last reply by Michael Sun [MSFT] - Tuesday, June 8, 2010 2:31 AM -
0 Votes
Varchar(n) not null and ReadXML ConstraintException
I have a SQL Server table (2008 R2) in which is a varchar(255) NOT NULL column.Answered | 3 Replies | 2542 Views | Created by CraigZ - Thursday, November 15, 2012 4:36 PM | Last reply by CraigZ - Friday, November 16, 2012 10:43 AM -
0 Votes
datagridview datatable not null field
field 3 in the database table is set to not null.Answered | 10 Replies | 6553 Views | Created by arkiboys - Thursday, September 22, 2011 1:12 PM | Last reply by Mike Dos Zhang - Tuesday, September 27, 2011 6:52 AM -
0 Votes
insert a null value into a date field
is there a difference between null and NULL ?Answered | 8 Replies | 12112 Views | Created by John Mendes - Friday, November 1, 2013 1:03 PM | Last reply by Gert-Jan Strik - Saturday, November 2, 2013 2:38 PM -
0 Votes
Count Column in MATRIX if data is not Null
In the Matrix data region, add the "EMPname" field as row group and the "Date" field as coulmn group.Answered | 2 Replies | 7500 Views | Created by Ekumar228 - Friday, December 28, 2012 12:20 PM | Last reply by Fanny Liu - Monday, December 31, 2012 1:57 AM -
0 Votes
Null Field
FWIW, Uninitialized DateTime fields come up as DateTime.MinValue, which you can check against, and uninitialized int fields are set to 0.Answered | 1 Replies | 3943 Views | Created by MDMoura - Tuesday, September 15, 2009 5:20 PM | Last reply by Noam Ben-Ami - MSFT1 - Tuesday, September 15, 2009 5:35 PM -
0 Votes
Linq to sql Null
Fields for database columns that can be null should be nullable types, which have a .HasValue property you can check to see if in fact the data for that column/row is ...Answered | 2 Replies | 2915 Views | Created by Normandy21 - Friday, July 15, 2011 10:44 AM | Last reply by kleinma - Friday, July 15, 2011 2:18 PM -
0 Votes
Add Field with 'Null" into query
> Every customer has group code and the are different for every customer.Answered | 6 Replies | 1399 Views | Created by MM from AUS - Monday, September 9, 2013 5:33 AM | Last reply by Chongtham Rajen Singh - Monday, September 9, 2013 10:18 AM -
0 Votes
Determining if a field is Null (that is empty)
To confirm, I know that calculated fields don't persist their data, but the calculated data is available during a workflow I assume based on your ...Answered | 3 Replies | 4719 Views | Created by ezadler - Tuesday, August 4, 2015 2:32 PM | Last reply by ezadler - Wednesday, August 5, 2015 10:39 AM -
1 Votes
SSIS : Concatenate NULL Field
=Field!Answered | 2 Replies | 7573 Views | Created by leCLEMS - Wednesday, August 17, 2011 5:41 PM | Last reply by Amit Srivastava - Thursday, August 18, 2011 11:35 AM - Items 1 to 20 of 1736409 Next ›
No announcements
