02-11-20, 06:18 PM
PHP كود :
DECLARE @x int;
set @x= (Select ROW_NUMBER() OVER(ORDER BY (SELECT 1)))
DECLARE @TBooksNames TABLE (id int, ChrCol nvarchar(255));
insert into @TBooksNames(id,ChrCol)values(@x,(CHAR(243)))
set @x += 1
insert into @TBooksNames(id,ChrCol)values(@x,(CHAR(240)))
set @x += 1
insert into @TBooksNames(id,ChrCol)values(@x,(CHAR(245)))
set @x += 1
insert into @TBooksNames(id,ChrCol)values(@x,(CHAR(246)))
set @x += 1
insert into @TBooksNames(id,ChrCol)values(@x,(CHAR(242)))
set @x += 1
insert into @TBooksNames(id,ChrCol)values(@x,(CHAR(241)))
set @x += 1
insert into @TBooksNames(id,ChrCol)values(@x,(CHAR(248)))
set @x += 1
insert into @TBooksNames(id,ChrCol)values(@x,(CHAR(250)))
Select * from @TBooksNames;
SELECT id,REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(ChrCol ,(CHAR(243)) ,'X'),(CHAR(240)) ,'X'),
(CHAR(245)) ,'X'),(CHAR(246)) ,'X'),(CHAR(242)) ,'X'),(CHAR(241)) ,'X'),(CHAR(248)) ,'X'),(CHAR(250)) ,'X') as x FROM @TBooksNames
بعض التسالي موفق انشاء الله .
سبحان الله وبحمده سبحان الله العظيم و الحمد لله ولا اله الا الله والله اكبر
