Can we save empty string into bigint column

Question

SQL SERVER gives error when my bigint column has '' empty string any one have an idea please share

Vikram Agrawal · Answer

Hi Danish, You can also use IsNull() function at the time of inserting the data like Insert Into myTbl (Col1,Col2,.....) Values (IsNull(@value1,0),IsNull(@value2,0),....) If the value have null then it will insert 0 instead of that otherwise it will insert you actual value. Thanks. Mark This Answer is Correct if it is helpful to you.

Joginder Banger · Answer

why are you used the if condition. pass a default parameters in table in design phase Default value Or Binding ('')

Danish Habib · Answer

I also found that it does now allow to insert empty string into the bigint column,Now i have 85 parameters all of type bigint some have values and some does not have ,I do not want to check if thistxtbox.value="" then insert DbNull.Value because it makes my code slow by putting 85 if else Now what to do please respond me

Joginder Banger · Answer

you can't save string in Bigint column. i have try this, just try i have create one table for you. CREATE TABLE [dbo].[mytable]( [id] [int] NULL, [testingone] [bigint] NOT NULL, [testingtwo] [varchar](max) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] and insert into value alter proc mytb 11,'',56 @id int , @first varchar(max), @second varchar(max) as begin insert into mytable values(@id,@first,@second) return end output is select * from mytb id testingone testingtwo 11 0 56 11 0 56 11 0 56 11 0 56

Can we save empty string into bigint column

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)