No announcements
Found 1445134 threads
-
1 Votesinsert null value in a textbox
i have a textbox which have a decimal value 0.5.Answered | 1 Replies | 2330 Views | Created by emmy_23 - Tuesday, March 12, 2013 9:50 AM | Last reply by FarnhamSurrey - Tuesday, March 12, 2013 3:17 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 | 5586 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 | 3904 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 | 1491 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
How to insert null values into the database?
However I will say that building update SQL statements like this is very dangerous and is not encouraged because of risk of SQL injection where someone could enter data into a ...Answered | 2 Replies | 3846 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
Allow null values+INSERT INTO
I'm not sure I understand why this allows null and my posted INSERT didn't?Answered | 6 Replies | 3125 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 | 961 Views | Created by I4QR1A - Friday, November 14, 2014 3:51 PM | Last reply by Visakh16 - Friday, November 14, 2014 5:52 PM -
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 | 2696 Views | Created by Fiendster - Sunday, May 12, 2013 10:34 PM | Last reply by Mike Lewis (SQLTuna) - Monday, May 13, 2013 9:24 AM -
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 | 10584 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 | 5184 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 | 5924 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 | 13968 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 | 8916 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 | 2226 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 | 12221 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 | 11727 Views | Created by thinkingeye - Tuesday, May 28, 2013 6:42 PM | Last reply by Michael Wandzik - Friday, May 31, 2013 11:39 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 | 1600 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 | 13812 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 -
0 Votes
Cannot insert the value NULL into column "TableFields"
The CoopInfo object instance may not have accepted the value you passed or may be resetting .CoopCode to null after you give it a value (we don't see what ...Answered | 4 Replies | 2457 Views | Created by Jlon - Thursday, August 4, 2011 3:35 PM | Last reply by Reed Kimble - Tuesday, August 9, 2011 3:27 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 | 1163 Views | Created by BrianSir - Friday, November 20, 2015 7:08 PM | Last reply by Alphonse G - Saturday, November 28, 2015 1:16 AM - Items 1 to 20 of 1445134 Next ›
No announcements
