No announcements
Found 2893636 threads
-
0 VotesHow to insert Empty String
; changes it to null ,then an error occured and prompt me xxx must be not null. How to insert an empty string value into a not ...Answered | 3 Replies | 7477 Views | Created by weakinverse - Monday, October 10, 2011 9:20 PM | Last reply by Tom_Overton - Tuesday, October 11, 2011 10:45 PM
-
1 Votes
how to insert null or empty string to datetime var ?
Took me a while to figure out how to handle nullable database datetime, I have found the following construct really ...Answered | 8 Replies | 38227 Views | Created by E_gold - Wednesday, September 15, 2010 2:38 PM | Last reply by Waratah - Tuesday, September 21, 2010 3:08 AM -
1 Votes
how to insert null or empty string to datetime var ?
Hi, As Zaiden suggested, you should use DateTime? so that you can set null value. Here is the extension method which parses the ...Answered | 9 Replies | 3815 Views | Created by E_gold - Wednesday, September 15, 2010 2:38 PM | Last reply by Louis.fr - Thursday, September 16, 2010 3:37 PM -
0 Votes
Insert null instead of empty string
Hello, simple question to all, I am going to do a simple insert, however I dont want '' which ...Answered | 3 Replies | 24924 Views | Created by StevenIB - Sunday, June 24, 2012 2:59 PM | Last reply by Sali SQL - Sunday, June 24, 2012 3:16 PM -
0 Votes
How to set OleDb parameter to null?
In the following fragment I want to set vID2 to NULL (and not to 0) if mID2 is an empty string. How do I do this? There is apparently no ...Answered | 2 Replies | 14894 Views | Created by PeterBDa - Sunday, September 5, 2010 3:31 PM | Last reply by PeterBDa - Sunday, September 5, 2010 7:14 PM -
0 Votes
Do Not Keep NULLS using SSIS Bulk Insert Task - Insert Empty Strings Instead of NULLS
with the Data Flow Task. Using the Bulk Insert Task, what must I do to have the Empty String values inserted into the ...Unanswered | 2 Replies | 5532 Views | Created by Ulysses B Brown Jr - Thursday, May 15, 2008 11:32 AM | Last reply by Ulysses B Brown Jr - Thursday, May 15, 2008 6:21 PM -
0 Votes
Binding Navigator Problem
register, all the boxes or combo boxes binding with the data source change to empty that It allow me insert a new row. But I dont know how can I do if I want that ... -
0 Votes
Insert empty value
Update - Thanks for responding quickly. I need to insert "empty" values. No empty string('') and no null value. The cell should contain no ...Answered | 12 Replies | 5393 Views | Created by asiaindian - Tuesday, December 29, 2009 7:03 AM | Last reply by Ranjith Kumar S - Wednesday, December 30, 2009 4:42 AM -
0 Votes
Empty string vs NULL in BCP + format file + CSV
> Empty string 2nd column; "hello","","world" If you want to import an empty string to the ...Answered | 1 Replies | 21732 Views | Created by SuraMan - Thursday, March 24, 2011 6:58 AM | Last reply by Stephanie Lv - Monday, March 28, 2011 5:32 AM -
0 Votes
How to cast empty string
I want to replace a column value with a null if the string is empty. I would have thought this simple expression would do it: RTRIM([FromContractSymbol]) ...Unanswered | 1 Replies | 6917 Views | Created by Jason Callas - Wednesday, March 22, 2006 11:01 PM | Last reply by Simon Sabin - Wednesday, March 22, 2006 11:28 PM -
0 Votes
Empty String
the user sets a non-empty value to that property and later, the user clears the value; the value of the property in the database would be "Empty ...Discussion | 1 Replies | 2935 Views | Created by Biff Loman - Friday, August 27, 2010 2:20 PM | Last reply by Toby Hu-MSFT - Monday, August 30, 2010 9:38 PM -
0 Votes
convert datetime.minvalue to empty string
how can i convert datetime.minvalue into an empty string when no date has been selected for a particular row. i need to implement this in xaml and inside a ...Unanswered | 1 Replies | 9439 Views | Created by madx - Friday, September 3, 2010 7:39 AM | Last reply by Skyseer - Tuesday, October 26, 2010 9:03 AM -
1 Votes
Empty string not empty?
Do you understand that in SQL a blank is character and that an empty string has no characters and is of a length zero?--CELKO-- Books in Celko Series for ...Answered | 4 Replies | 692 Views | Created by Naomi N - Wednesday, May 18, 2016 9:58 PM | Last reply by Naomi N - Thursday, May 19, 2016 4:31 PM -
0 Votes
How to pass empty string in parameter
0 but no luck. Thanks, SSRSRptAnswered | 3 Replies | 6784 Views | Created by Pratul_sri - Thursday, January 27, 2011 2:20 PM | Last reply by Albert Ye - Tuesday, February 1, 2011 7:04 AM -
1 Votes
Empty cells don't translate to empty string
string key = ((Range)ro.Cells[1, 1]).Value2.ToString() When the targetted cell is empty, I would just be happy to get a empty string in ...Answered | 1 Replies | 3395 Views | Created by Lalbatros - Wednesday, June 30, 2010 2:04 PM | Last reply by incre-d - Wednesday, June 30, 2010 2:43 PM -
0 Votes
Empty String
, which an empty string is. If you want a guarantee that data with length is added to the table, you have to add a check constraint as Naom ...Answered | 5 Replies | 5137 Views | Created by goms - Friday, August 6, 2010 4:30 PM | Last reply by Atif-ullah Sheikh - Friday, August 6, 2010 7:26 PM -
0 Votes
Not binding since no visible was made
loaded already and they are closed successfully. But Those TabItems in the background has their TextBox value to be "" (Empty String) since those Tabs was not ...Unanswered | 0 Replies | 3641 Views | Created by Itzik Katzav - Wednesday, January 10, 2007 12:27 PM -
0 Votes
How to remove JSON empty string/values
HOLD ON! What exactly do you mean by: "The only problem is that I don't want to pass string values which are NULL/empty text ...Proposed | 2 Replies | 608 Views | Created by TRX123456 - Tuesday, March 26, 2019 12:33 AM | Last reply by Johns-305 - Wednesday, March 27, 2019 12:33 PM -
0 Votes
Biztalk Oracle Adapter for Select Procedure
Generate metadata...through this wizard i m using configured receive location). i am able to see insert, update procedures but unable to see get or ...Unanswered | 1 Replies | 8238 Views | Created by Girish Fuluskar - Sunday, March 14, 2010 5:13 AM | Last reply by Girish Fuluskar - Tuesday, March 9, 2010 10:11 AM -
0 Votes
How to check string empty in VBA
Empty, Null and so on doesn't work. Need a solutionAnswered | 1 Replies | 702 Views | Created by 4399 - Friday, August 31, 2018 1:11 PM | Last reply by Seiya Su - Friday, August 31, 2018 1:13 PM - Items 1 to 20 of 2893636 Next ›
No announcements
