No announcements
Found 2748320 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 | 5598 Views | Created by SBolton - Friday, April 16, 2010 8:00 PM | Last reply by Miloslav Peterka - Friday, April 16, 2010 8:49 PM
-
0 Votes
how to insert null value
Hello, The stored procedure should be like below CREATE PROCEDURE Procedure_Name ( @BankAcNo INT = ...Answered | 5 Replies | 5194 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
Inserting null values
How about: Insert into PLANIND Select ISNULL(Polind, 'R3') from RateInd HTH!Answered | 2 Replies | 3914 Views | Created by Aaban_M - Wednesday, August 5, 2009 7:19 AM | Last reply by richbrownesq - Wednesday, August 5, 2009 7:21 AM -
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 | 3858 Views | Created by sh 2020 - Thursday, August 2, 2012 3:00 PM | Last reply by sh 2020 - Friday, August 3, 2012 6:11 AM -
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 | 13845 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
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 | 1503 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 | 2346 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 | 3137 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 | 979 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 | 10619 Views | Created by RAGS1109 - Monday, April 16, 2012 10:06 PM | Last reply by vinaypugalia - Tuesday, April 17, 2012 6:10 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 | 5933 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 -
1 Votes
trigger problem inserting null values??
but if i just want to enter "record inserted" into a table how to do this after the record is inserted.Answered | 21 Replies | 8936 Views | Created by chandu123 - Sunday, October 3, 2010 10:39 AM | Last reply by Erland Sommarskog - Wednesday, October 6, 2010 9:59 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 | 11752 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
Insert NULL values in SQL database
Hi, Actually I always prefer logical null rather then NULL Thanks Md.Answered | 13 Replies | 13994 Views | Created by Forzazanzi - Wednesday, April 20, 2011 10:33 AM | Last reply by Vishvvas - Thursday, April 28, 2011 10:23 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 | 2711 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
Cannot insert Value NULL into column
And the data flow is trying to insert NULL into it.Answered | 3 Replies | 2238 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
How to insert Null values to a float column in the database
As you have string values like "NULL" in your data.Answered | 10 Replies | 21475 Views | Created by lucki2005 - Thursday, November 10, 2011 4:52 AM | Last reply by Mo Saleh - Monday, May 23, 2016 2:08 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 | 12243 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 -
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 | 1612 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 -
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 ...Answered | 10 Replies | 1177 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 2748320 Next ›
No announcements
