Hi dear,
private void FxREPLICATE()
{
SqlConnection objConn1 = new SqlConnection("Data Source= Sql Server Name ;Initial Catalog= Database Name ;user id=sa; password=123;");
string sql = "select REPLICATE ('0',8-DATALENGTH (EmployeeCode ))+EmployeeCode as 'EmpCode' from TBL_DKCSV";
SqlCommand cmd = new SqlCommand(sql, objConn1);
objConn1.Open();
cmd.ExecuteNonQuery();
objConn1.Close();
}