ÎÁ×ÅÒÎÏÅ ÞÔÏ ÂÙ ÎÅ ÌÏÍÁÔØ ÇÏÌÏ×Õ ÐÏ ÐÏ×ÏÄÕ +0
ÌÕÞÛÅ ÚÁ×ÅÓÔÉ ÅÍÕ ÉÎÄÅËÓ iddoc,.id Ñ ÐÒÁ×?
ÁÇÁ, É ÐÏ ËÁÖÄÏÍÕ ÓÏÞÅÔÁÎÉÀ ÐÏÌÅÊ, ÜÔÏ ÎÅÐÒÁ×ÉÌØÎÏ
ÔÅÍ ÂÏÌÅÅ ÞÔÏ Ó ÐÏÇÁÛÅÎÎÙÍ ÞÅÒÅÚ+0 ÉÎÄÅËÓÏÍ
ÓËÏÒÏÓÔØ ×ÙÐÏÌÎÅÎÉÑ ÚÁÐÒÏÓÁ ÕÓÔÒÁÉ×ÁÅÔ ÂÏÌÅÅ ÞÅÍ
äÁÖÅ ÅÓÌÉ ÚÁÐÉÓÅÊ ÎÅ ×ÏÚ×ÒÁÝÁÅÔÓÑ, ÉÎÄÅËÓ ÐÏ ID ÓËÁÎÉÒÕÅÔÓÑ ÃÅÌÉËÏÍ.
--
äÍÉÔÒÉÊ åÍÁÎÏ×
ÉÚ ÔÏÊ ÖÅ ÓÅÒÉÉ:
ÅÓÔØ ÔÁÂÌÉÃÁ Label - 30 ÚÁÐÉÓÅÊ
ÐÏÌÅ Fullname 80 ÓÉÍ×ÏÌÏ×, ÉÎÄÅËÓÉÒÏ×ÁÎÎÏÅ
ÚÁÐÒÏÓ
select label.Id, label.Code, label.FullName
from label
where label.Fullname like '%ðïéóë%'
order by
ÉÚ ÔÏÊ ÖÅ ÓÅÒÉÉ:
ÅÓÔØ ÔÁÂÌÉÃÁ Label - 30 ÚÁÐÉÓÅÊ
ÐÏÌÅ Fullname 80 ÓÉÍ×ÏÌÏ×, ÉÎÄÅËÓÉÒÏ×ÁÎÎÏÅ
ÚÁÐÒÏÓ
select label.Id, label.Code, label.FullName
from label
where label.Fullname like '%ðïéóë%'
order by label.Fullname
÷ FB1.5 ×ÙÐÏÌÎÑÅÔÓÑ ÎÅÓËÏÌØËÏ ÒÁÚ ÂÙÓÔÒÅÅ, ÞÅÍ × ×ÅÒÓÉÉ 2
ÚÁÐÒÏÓ
ÎÁÔÁ [EMAIL PROTECTED] wrote:
ÜÔÏ ÔÁË É ÂÕÄÅÔ ×ÓÅÇÄÁ? ÐÅÒÅÐÉÓÙ×ÁÔØ ÐÒÏÇÕ ÎÁ ÇÁÛÅÎÉÅ ÉÎÄÅËÓÏ×
× ÓÏÒÔÉÒÏ×ËÅ?
÷ FB2 - ÄÁ. ðÏÎÉÍÁÅÛØ ÌÉ, ÏÔËÌÀÞÉÔØ ÉÎÄÅËÓ ×ÓÅÇÄÁ ÍÏÖÎÏ. á ×ÏÔ ×ËÌÀÞÉÔØ ÅÇÏ
× 1.5 ÎÅ ÕÄÁÓÔÓÑ × ÐÒÉÎÃÉÐÅ. ëÒÏÍÅ ÔÏÇÏ, ÔÕÔ ËÏÎÆÌÉËÔ ÉÎÔÅÒÅÓÏ×. íÎÏÇÉÅ ÌÀÄÉ
ÈÏÔÑÔ, ÎÁÐÒÉÍÅÒ, ÐÒÉ ×ÙÂÏÒËÅ
ÎÁÔÁ [EMAIL PROTECTED] wrote:
Ô.Å. Ñ ÔÁË ÐÏÎÉÍÁÀ - ÇÁÓÉÔØ ÉÎÄÅËÓÙ ÎÕÖÎÏ ÐÏ ÔÅÍ ÐÏÌÑÍ × ÓÏÒÔÉÒÏ×ËÅ
ËÏÔÏÒÙÅ (ÉÎÄÅËÓÙ) ÎÅ ÉÓÐÏÌØÚÏ×ÁÎÙ × ÚÁÐÒÏÓÁÈ ÔÁË?
çÁÓÉÔØ ÎÕÖÎÏ ÔÏÌØËÏ × ORDER BY ËÌÑÕÚÅ. ïÓÔÁÌØÎÏÅ ÏÐÔÉÍÉÚÁÔÏÒ ÓÁÍ ÒÁÚÒÕÌÉÔ.
--
äÍÉÔÒÉÊ åÍÁÎÏ×
ÎÁÔÁ [EMAIL PROTECTED] wrote:
× ÎÁÓËÏÌØËÏ ÓËÏÒÏÍ ÂÕÄÕÝÅÍ?
÷ 3.0, ÎÅ ÒÁÎØÛÅ.
--
äÍÉÔÒÉÊ åÍÁÎÏ×
Vadim Mescheryakov [EMAIL PROTECTED] wrote:
îÏ ÐÏÞÅÍÕ ÐÒÏÉÚ×ÏÄÉÔÅÌØÎÏÓÔØ ÔÁË ÕÐÁÌÁ ÎÁ ÜÔÏÍ ÚÁÐÒÏÓÅ?
ïÎ ÎÅ ×ÏÚ×ÒÁÝÁÅÔ ÎÉ ÏÄÎÏÊ ÚÁÐÉÓÉ
äÁÖÅ ÅÓÌÉ ÚÁÐÉÓÅÊ ÎÅ ×ÏÚ×ÒÁÝÁÅÔÓÑ, ÉÎÄÅËÓ ÐÏ ID ÓËÁÎÉÒÕÅÔÓÑ ÃÅÌÉËÏÍ.
--
äÍÉÔÒÉÊ åÍÁÎÏ×
Dmitry Yemanov [EMAIL PROTECTED]
ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:[EMAIL PROTECTED]
Vadim Mescheryakov [EMAIL PROTECTED] wrote:
îÏ ÐÏÞÅÍÕ ÐÒÏÉÚ×ÏÄÉÔÅÌØÎÏÓÔØ ÔÁË ÕÐÁÌÁ ÎÁ ÜÔÏÍ ÚÁÐÒÏÓÅ?
ïÎ ÎÅ ×ÏÚ×ÒÁÝÁÅÔ ÎÉ ÏÄÎÏÊ ÚÁÐÉÓÉ
äÁÖÅ ÅÓÌÉ ÚÁÐÉÓÅÊ ÎÅ ×ÏÚ×ÒÁÝÁÅÔÓÑ, ÉÎÄÅËÓ ÐÏ ID ÓËÁÎÉÒÕÅÔÓÑ
ðÒÉ ÐÅÒÅÈÏÄÅ Ó FB CS 1.5 ÎÁ FB CS 2.0 RC1
ÓÔÏÌËÎÕÌÉÓØ Ó ÔÁËÏÊ ÐÒÏÂÌÅÍÏÊ
äÁÎÎÙÅ:
Doc - 12 000 000 ÚÁÐÉÓÅÊ ÉÎÄÅËÓ ÐÏ ÐÏÌÀ IdDoc, ÐÅÒ×ÉÞÎÙÊ ËÌÀÞ ÐÏ ÐÏÌÀ Id
Goods - 300 000 ÚÁÐÉÓÅÊ ÐÅÒ×ÉÞÎÙÊ ËÌÀÞ ÐÏ ÐÏÌÀ Id
úÁÐÒÏÓ
select d.id, d.kol, d.cena, g.name
from doc d
left outer join gods g on
Vadim Mescheryakov [EMAIL PROTECTED] wrote:
úÁÐÒÏÓ
select d.id, d.kol, d.cena, g.name
from doc d
left outer join gods g on g.id=d.idlabel
where d.iddoc = 5
order by d.id
÷ ÞÅÍ ÍÏÖÅÔ ÂÙÔØ ÐÒÉÞÉÎÁ?
÷ ÔÏÍ, ÞÔÏ FB2 ÎÁÕÞÉÌÓÑ ÉÓÐÏÌØÚÏ×ÁÔØ ÐÌÁÎ ORDER ÄÌÑ ×ÎÅÛÎÉÈ ÄÖÏÊÎÏ×, ÞÅÇÏ
FB15 ÎÅ ÕÍÅÌ ×
÷ ÔÏÍ, ÞÔÏ FB2 ÎÁÕÞÉÌÓÑ ÉÓÐÏÌØÚÏ×ÁÔØ ÐÌÁÎ ORDER ÄÌÑ ×ÎÅÛÎÉÈ ÄÖÏÊÎÏ×, ÞÅÇÏ
FB15 ÎÅ ÕÍÅÌ × ÐÒÉÎÃÉÐÅ. ïÔËÌÀÞÁÊ ÈÉÎÔÏÍ +0, ÅÓÌÉ ÔÅÂÅ ÜÔÏ ÎÅ ÎÁÄÏ.
üÔÏ Ñ ÓÏÏÂÒÁÚÉÌ É ÏÃÅÎÉÌ ËÁË ×ÙÒÏÓÌÁ ÓËÏÒÏÓÔØ ÚÁÐÒÏÓÏ× ÓÏ ×ÎÅÛÎÉÍÉ ÄÖÏÉÎÁÍÉ.
îÏ ÐÏÞÅÍÕ ÐÒÏÉÚ×ÏÄÉÔÅÌØÎÏÓÔØ ÔÁË ÕÐÁÌÁ ÎÁ ÜÔÏÍ ÚÁÐÒÏÓÅ?
ïÎ ÎÅ ×ÏÚ×ÒÁÝÁÅÔ
11 matches
Mail list logo