2
Answers

Write a Query to identify Leading Zero's are inserted or not

i have created a Table with Column Datatype as Int
below is the Data inserted into it
00012,0012,000000136.after Inserting.How to Write a Query to identify Leading Zero's are Inserted into Particular Column or not
 
Ex:-
Create Table Test4(EmpSal int)
insert into Test4 Values(00012),(0012),(000000126),(0000135)
Answers (2)