Can we save empty string into bigint column

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.

why are you used the if condition.

pass a default parameters in table in design phase

Default value Or Binding ('')

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