sql server - what will be happend when inserting integer value as string in sql query -

sql server - what will be happend when inserting integer value as string in sql query -

the table construction

empid int identity empname varchar(50) empage int

while inserting values table next query

insert tablename values('g','4');

now query executing well.

so whats difference between next query , above query

insert tablename values('go',5);

the first query 'implicit cast' literal varchar value '4' value 4 (an integer)

the sec 1 not.

the sec 1 bit improve practice.

both of them bad practice regardless because should include column names well:

insert tablename (empname,empage) values('go',5);

sql sql-server