Ðåêëàìà
Åñòü íåáîëüøîé ñêðèïò íà MS SQL, íóæíî ïåðåâåñòè åãî íà MySQL (÷òîáû îí äåëàë òî-æå ñàìîå, íî íà MySQL-ñåðâåðå).SET ANSI_NULLS OFFGOSET QUOTED_IDENTIFIER OFFGOCREATE PROCEDURE ExportStockItems_old( ··· date, ··· int)as begindeclare ··· nvarchar(20), ··· int, ··· int, ··· nvarchar(20)declare ··· nvarchar(5) = ' 'declare ··· table (id int, Size nvarchar(10))declare size_cursor cursor forselect id, AvailableSizes from StockItems where Date = ···open size_cursorfetch next from size_cursor into ··· ···while ··· = 0begin set ··· = charindex(··· while ··· != 0 begin set ··· = substring(··· insert into ··· (id, size) values (··· ··· set ··· = substring(··· set ··· = charindex(··· end insert into ··· (id, size) values (··· ··· fetch next from size_cursor into ··· ···endclose size_cursordeallocate size_cursorselect Category = isnull (CM.Category_RU, SI.Category), SubCategory = isnull(CM.SubCategory_RU, SI.SubCategory), SI.ArticleNumber, convert (nvarchar(20), SI.Ar...
Äðóãèå îòêðûòûå çàäàíèÿ:
Áþäæåò: 2 000 ð. Îòðèñîâêà ìåáåëè äëÿ èíòåðíåò-ìàãàçèíà (200 êàðòî÷åê òîâàðà), ôîòî ïðåäîñòàâëÿåòñÿ. Äèçàéí ìåáåëè (êóõíè, øêàôà) äëÿ êàðòî÷êè òîâàðà â èíòåðíåò ìàãàçèíå. Îòðèñîâê…
Áþäæåò: 1 700 ð. Íóæíî îñòàâèòü ìíåíèå î ðàáîòå ñàéòà. Ðàáîòàåì ÷åðåç òã, ïèñàòü··· Îïëàòà ïîñëå ïóáëèêàöèè, çàäàíèé ìíîãî, ñòàâêà ñòàáèëüíàÿ
Áþäæåò: 4 000 ð. • Îïèñàíèÿ çàäàíèÿ: Èùåì êîïèðàéòåðà äëÿ íàïèñàíèÿ îòçûâîâ è îïèñàíèé òîâàðîâ äëÿ ìàãàçèíà ýëåêòðîíèêè. Ðàáîòà ïîäõîäèò âñåì, êòî óìååò ãðàìîòíî ïèñàòü — îïûò íåîáÿ…
ïîèñê çàäàíèé
Ïåðåâåñòè ñêðèïò ñ MS SQL íà MySQL
Ðåêëàìà
Ïåðåâåñòè ñêðèïò ñ MS SQL íà MySQL
Åñòü íåáîëüøîé ñêðèïò íà MS SQL, íóæíî ïåðåâåñòè åãî íà MySQL (÷òîáû îí äåëàë òî-æå ñàìîå, íî íà MySQL-ñåðâåðå).
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE ExportStockItems_old
(
··· date,
··· int
)
as begin
declare ··· nvarchar(20), ··· int, ··· int, ··· nvarchar(20)
declare ··· nvarchar(5) = ' '
declare ··· table (id int, Size nvarchar(10))
declare size_cursor cursor for
select id, AvailableSizes from StockItems where Date = ···
open size_cursor
fetch next from size_cursor into ··· ···
while ··· = 0
begin
set ··· = charindex(···
while ··· != 0
begin
set ··· = substring(···
insert into ··· (id, size) values (··· ···
set ··· = substring(···
set ··· = charindex(···
end
insert into ··· (id, size) values (··· ···
fetch next from size_cursor into ··· ···
end
close size_cursor
deallocate size_cursor
select
Category = isnull (CM.Category_RU, SI.Category),
SubCategory = isnull(CM.SubCategory_RU, SI.SubCategory),
SI.ArticleNumber,
convert (nvarchar(20), SI.Ar...