Sql Query with decimal Values

Hello. I need the query which will populate the value in decimal.

ex: I have a field EMP_ID in Employee table.

EMPID values is 1 in table. now the value need to be as 1.00 in table.

how we can wright a query to get it

If you're trying to change the type of data stored in the column, you can do so with an alter statement like:

alter table #test alter column emp_id decimal(5,2) not null