SELECT
ROW_NUMBER() over(order by OgrenciId) AS SiraNo
,[OgrenciId]
,REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE([OgrenciAdSoyad],'Ş','S'),'Ç','C'),'Ö','O'),'İ','ı'),'Ğ','G'),'Ü','u') AS [YeniOgrenciAdSoyad]
,[OgrenciAdSoyad] as EskiOgrenciAdSoyad
,[OgrenciNo]
,[SinifID]
,[OgretmenID]
FROM [OkulDB].[dbo].[Ogrenci_Tbl]
