No announcements
Found 1662673 threads
-
0 VotesCannot insert null into a not null column error
Thanks Is Identity insert property set?Answered | 8 Replies | 1180 Views | Created by sshekhar2 - Thursday, November 27, 2014 12:43 AM | Last reply by sshekhar2 - Thursday, November 27, 2014 5:26 AM
-
0 Votes
INSERT INTO Null or Not Null Dates
However, as more and more date fields get added to the equation I have multiple insert statements to handle one insert for various conditions various one statement ...Answered | 10 Replies | 948 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
Setting ID value upon insert
How can I set the value of an ID column to MAX(ID)+1 upon insert of a new row?Answered | 4 Replies | 967 Views | Created by Y a h y a - Wednesday, July 8, 2020 9:06 PM | Last reply by Echo Liuz - Friday, July 10, 2020 2:02 AM -
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 | 3737 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
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 | 5386 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
BULK INSERT AND NOT NULL CONSTRAINT
If you have an int column, you get an error.Answered | 12 Replies | 3581 Views | Created by Rajkumar5055 - Wednesday, October 3, 2012 8:45 AM | Last reply by Rajkumar5055 - Friday, October 12, 2012 2:33 PM -
0 Votes
Inserting null into database
also, i used an else statement as if I didnt set any value, the system was throwing an error requesting the @shiftplan_id to be specified.Answered | 4 Replies | 3516 Views | Created by amthekkel - Tuesday, April 7, 2009 2:37 PM | Last reply by JohnGrove - Wednesday, April 8, 2009 10:01 PM -
0 Votes
Inserting default value instead of null
So, to get rid of the above error, you have got 2 options - Stop using the column name [Made in..] in your INSERT statement ...Answered | 4 Replies | 10122 Views | Created by RAGS1109 - Monday, April 16, 2012 10:06 PM | Last reply by vinaypugalia - Tuesday, April 17, 2012 6:10 AM -
2 Votes
inserting into a not null field
you can use while bulk insert.Answered | 7 Replies | 1223 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
Cannot insert NULL
What happens if you try to insert the blanks with OSQL?Answered | 3 Replies | 740 Views | Created by Sid_2014 - Monday, June 27, 2016 5:24 PM | Last reply by Johns-305 - Monday, June 27, 2016 8:07 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 | 1317 Views | Created by hamonbatra - Friday, December 20, 2013 1:13 AM | Last reply by Dan Guzman - Friday, December 20, 2013 3:04 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 | 2957 Views | Created by quarck2 - Sunday, March 3, 2013 7:20 PM | Last reply by quarck2 - Thursday, March 7, 2013 4:47 PM -
1 Votes
SSIS Null inserts in tables
The zeroes are inserted as the Flat File Source replaces null values by 0 when fetching the data.Answered | 7 Replies | 6901 Views | Created by karthikbjadav - Tuesday, March 29, 2011 12:33 PM | Last reply by Koen Verbeeck - Thursday, March 31, 2011 5:46 AM -
0 Votes
how to insert null value
Still, the parameter in stored procedure should be nullable otherwise it will generate error.Answered | 5 Replies | 5030 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
insert null value in a textbox
when the textbox is disabled value null should be inserted in the database tablle private void checkBox1_CheckedChanged(object sender, ...Answered | 1 Replies | 2123 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
Insert null instead of empty string
Try below declare @name varchar(100) SET @name = '' Insert into Student(Sno, Name, Marks) select 1, Case When @name = '' then null else @name end, ...Answered | 3 Replies | 30799 Views | Created by StevenIB - Sunday, June 24, 2012 2:59 PM | Last reply by Sali SQL - Sunday, June 24, 2012 3:16 PM -
3 Votes
INSERTING NULL VALUES
You are right NULL !Answered | 6 Replies | 781 Views | Created by I4QR1A - Friday, November 14, 2014 3:51 PM | Last reply by Visakh16 - Friday, November 14, 2014 5:52 PM -
0 Votes
Insert NULL values in SQL database
What is the error?Answered | 13 Replies | 13719 Views | Created by Forzazanzi - Wednesday, April 20, 2011 10:33 AM | Last reply by Vishvvas - Thursday, April 28, 2011 10:23 AM -
4 Votes
How to insert a NULL in a SQL_TYPE_TIMESTAMP column ?
The script to create table is: CREATE TABLE TEST_TABLE_RDD_ODBCRDD ( [SR_RECNO] [numeric](15, 0) IDENTITY (1, 1) NOT ...Answered | 14 Replies | 15334 Views | Created by Marcelo Lombardo - Wednesday, April 29, 2009 8:30 PM | Last reply by Marcelo Lombardo - Thursday, May 7, 2009 9:47 AM -
0 Votes
Cannot insert Value NULL into column
And the data flow is trying to insert NULL into it.Answered | 3 Replies | 2055 Views | Created by mwavery - Tuesday, May 21, 2013 1:10 AM | Last reply by Harry Bal - Wednesday, May 22, 2013 8:52 PM - Items 1 to 20 of 1662673 Next ›
No announcements
