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
)

SELECT TOP in MS SQL

Select the top rows from your select query

SELECT TOP 1 ELG_ORDER FROM HS_HR_BM_MEDICAL_ELG_DST WHERE EMP_NUMBER = @EMP_NUMBER ORDER BY ELG_ORDER DESC

SQL CURSOR Syntax

Follow the below MS SQL syntax for create new Cursor

DECLARE emFIRST CURSOR FOR
SELECT EMP_NUMBER FROM HS_HR_EMPLOYEE
OPEN emFIRST
FETCH NEXT FROM emFIRST INTO  @EMP_NUMBER
WHILE (@@fetch_status <> -1)      
BEGIN
SELECT @CORPORATE = CT_CODE FROM HS_HR_EMPLOYEE
PRINT @EMP_NUMBER
PRINT '---------------------'
FETCH NEXT FROM emFIRST INTO  @EMP_NUMBER  
END
CLOSE  emFIRST
DEALLOCATE emFIRST