No announcements
Found 1368146 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 | 5597 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
Inserting null values
Use IsNULL(PlanIND,'R3') in your insert statement this will insert R3 where you have null value.Answered | 2 Replies | 3912 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
insert to null value
This problem cannot be addressed in the query but can be fixed with a change to the children_id column to allow NULL values.Answered | 1 Replies | 1500 Views | Created by hamonbatra - Friday, December 20, 2013 1:13 AM | Last reply by Dan Guzman - Friday, December 20, 2013 3:04 AM -
1 Votes
insert null value in a textbox
i have a textbox which have a decimal value 0.5.Answered | 1 Replies | 2342 Views | Created by emmy_23 - Tuesday, March 12, 2013 9:50 AM | Last reply by FarnhamSurrey - Tuesday, March 12, 2013 3:17 PM -
0 Votes
Allow null values+INSERT INTO
I'm not sure I understand why this allows null and my posted INSERT didn't?Answered | 6 Replies | 3134 Views | Created by quarck2 - Sunday, March 3, 2013 7:20 PM | Last reply by quarck2 - Thursday, March 7, 2013 4:47 PM -
3 Votes
INSERTING NULL VALUES
To add to above NULL is not regarded as a value in sql server under default conditions.Answered | 6 Replies | 973 Views | Created by I4QR1A - Friday, November 14, 2014 3:51 PM | Last reply by Visakh16 - Friday, November 14, 2014 5:52 PM -
0 Votes
Inserting default value instead of null
are you defining the column as NOT NULL, and explicitly specifying NULL for that column in the insert statement?Answered | 4 Replies | 10607 Views | Created by RAGS1109 - Monday, April 16, 2012 10:06 PM | Last reply by vinaypugalia - Tuesday, April 17, 2012 6:10 AM -
0 Votes
how to insert null value
Hello, The stored procedure should be like below CREATE PROCEDURE Procedure_Name ( @BankAcNo INT = ...Answered | 5 Replies | 5191 Views | Created by Hitesh1508 - Tuesday, August 31, 2010 7:23 AM | Last reply by Atif-ullah Sheikh - Wednesday, September 1, 2010 10:19 AM -
1 Votes
Null values are being inserted in columns not allowing Null values
SQL Server will not allow NULL values to be inserted into columns that do not allow NULL.Answered | 3 Replies | 5930 Views | Created by Mahesh C Sharma - Saturday, January 14, 2012 5:27 AM | Last reply by Dan Guzman - Saturday, January 14, 2012 2:31 PM -
0 Votes
Insert NULL values in SQL database
Hi, Actually I always prefer logical null rather then NULL Thanks Md.Answered | 13 Replies | 13984 Views | Created by Forzazanzi - Wednesday, April 20, 2011 10:33 AM | Last reply by Vishvvas - Thursday, April 28, 2011 10:23 AM -
1 Votes
trigger problem inserting null values??
We are inserting that 2 values, into 2 local variables @empid and @Name Then in next ...Answered | 21 Replies | 8928 Views | Created by chandu123 - Sunday, October 3, 2010 10:39 AM | Last reply by Erland Sommarskog - Wednesday, October 6, 2010 9:59 PM -
0 Votes
Cannot insert Value NULL into column
And the data flow is trying to insert NULL into it.Answered | 3 Replies | 2236 Views | Created by mwavery - Tuesday, May 21, 2013 1:10 AM | Last reply by Harry Bal - Wednesday, May 22, 2013 8:52 PM -
0 Votes
insert a null value into a date field
Most likely, there is a trigger on the table that replaces the NULL with the magic value of 1 Jan 1990.Answered | 8 Replies | 12237 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 -
1 Votes
Cannot insert the value NULL into column
By doing this you will have the records inserted containing the value '' in the 7th column.Answered | 11 Replies | 11747 Views | Created by thinkingeye - Tuesday, May 28, 2013 6:42 PM | Last reply by Michael Wandzik - Friday, May 31, 2013 11:39 AM -
0 Votes
Cannot insert the value NULL into column
Therefore if your @pubCode value is NULL, then you first need to lookup your code value from the PUBLISHER table.Answered | 3 Replies | 2707 Views | Created by Fiendster - Sunday, May 12, 2013 10:34 PM | Last reply by Mike Lewis (SQLTuna) - Monday, May 13, 2013 9:24 AM -
4 Votes
Bulk Insert with Null Value
BULK INSERT is a binary tool, and is not the most flexible guy in town.Answered | 10 Replies | 1607 Views | Created by Hrishi K - Thursday, December 10, 2015 6:59 PM | Last reply by André Renato Furtado - Friday, December 11, 2015 2:34 PM -
3 Votes
how to insert defautl value in case of NULL?
The test i used was: CREATE TABLE A ( A VARCHAR(20), B NCHAR(10) DEFAULT N'Def', C INT DEFAULT -1 ); INSERT ...Answered | 15 Replies | 13834 Views | Created by waleed_m_m - Monday, June 15, 2009 6:20 AM | Last reply by waleed_m_m - Wednesday, June 17, 2009 12:52 PM -
1 Votes
How to insert null values into the database?
Since you are building a SQL statement with strings, you could use an IF() operator and return "null" when the textbox is blank, and return the value when it is not.Answered | 2 Replies | 3855 Views | Created by sh 2020 - Thursday, August 2, 2012 3:00 PM | Last reply by sh 2020 - Friday, August 3, 2012 6:11 AM -
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 | 1175 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
Encounter cannot insert the value NULL into column
I think you need to modify the statement to insert a non-null value or specify a default value.Answered | 14 Replies | 7185 Views | Created by ngs5 - Tuesday, May 11, 2010 7:11 AM | Last reply by Naomi N - Monday, May 17, 2010 1:57 PM - Items 1 to 20 of 1368146 Next ›
No announcements
