Text Formating for Fixed Length in Excel

Excel function for format the cell content with fixed length
=TEXT(B2,"000000")

REPLICATE

 You can fix the character length by using below

UPDATE HS_HR_CORPORATE_TITLE_NEPAL
SET CT_CODE = REPLICATE ('0',6- LEN (CT_CODE + 306)) + CAST ((CT_CODE + 306) AS VARCHAR)

UPPER Case in MS SQL

 By using the UPPER(), you can retrieve your character data with caps.

SELECT RTRIM(LTRIM(UPPER(DSG_NAME))) FROM HS_HR_DESIGNATION

GROUP BY

SELECT DBGROUP_ID,COUNT(*)
FROM HS_HR_DESIGNATION
GROUP BY DBGROUP_ID

Apply the Conditions with GROUP BY

SELECT DBGROUP_ID,COUNT(*)
FROM HS_HR_DESIGNATION
GROUP BY DBGROUP_ID
HAVING COUNT(*) > 6 

Alter Column Ms SQL

 Fulfill the requirement of changing data type of particular field.

ALTER TABLE EMP_NEPAL
ALTER COLUMN SAL_GRD_CODE VARCHAR(10)

Oracle Update Query

The syntax for the update in Oracle is little bit differ than MS SQL. The below will describes simple query which was fulfilled my requirement.

UPDATE JAN_TAX_2012 J
SET J.EMP_NUMBER = 
(
SELECT E.EMP_NUMBER
FROM HS_HR_EMPLOYEE E
WHERE E.EMP_DISPLAY_NUMBER = J.EMP_DISPLAY_NUMBER
)
WHERE EXISTS
(
SELECT E.EMP_NUMBER
FROM HS_HR_EMPLOYEE E
WHERE E.EMP_DISPLAY_NUMBER = J.EMP_DISPLAY_NUMBER
)