Will it auto convert datatype???

#1

When i do this statement:

insert into table (cost) values ('2')

cost column is a bigint datatype.

will it auto convert the string 2 into integer 2???

#2

Hi

See the topic "CAST and CONVERT" in books online for information regarding
when you will need an implicit or explicit convertion.

John

<chuayongquan (AT) hotmail (DOT) com> wrote

Quote:

When i do this statement:

insert into table (cost) values ('2')

cost column is a bigint datatype.

will it auto convert the string 2 into integer 2???

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Will it auto convert datatype???

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Will it auto convert datatype??? - 05-15-2005 , 09:11 AM

Re: Will it auto convert datatype??? - 05-15-2005 , 10:10 AM