Results 1 to 7 of 7
Thread: Âúïðîñ çà SQL
Hybrid View
-
26th February 2012 17:19 #1Registered User
Join Date: Jun:2011
Location: Ñîôèÿ
Posts: 120
Âúïðîñ çà SQL
Ìîæå ëè äà áúäå èçïîëçâàíà êëàóçàòà Having áåç, äà ðå÷åì, â äàäåíàòà çàÿâêà äà ñå èçïîëçâà êëàóçàòà Group by?
-
26th February 2012 17:55 #2Registered User
Join Date: Sep:2003
Location: Where you live
Posts: 976
íå
-
26th February 2012 18:01 #3Registered User
Join Date: Jun:2011
Location: Ñîôèÿ
Posts: 120
Òóê ñà íàïðàâèëè òî÷íî òîâà: http://manuals.sybase.com/onlinebook...9481;pt=9213/*
-
26th February 2012 18:09 #4Registered User
Join Date: Sep:2003
Location: Where you live
Posts: 976
"Transact-SQL" äîðè íå ñÚì ãî ÷óâàë, ío sybase áÿõà ñòàðà ôèðìà, îò êîÿòî MS êóïèõà òåõíîëîãèÿòà çà SQL
. ìîæå äà ñòàâà ñÚñ íÿêàêÚâ ñòàð äèàëåêò íà SQL âåðîÿòíî, íî ïî ñòàíäàðò íå ìîæå.
Last edited by dzk; 26th February 2012 at 18:25.
-
27th February 2012 12:11 #5Registered User
Join Date: Jan:2012
Location: Ñîôèÿ
Posts: 6
Òîâà å íÿêàêâà ïúëíà ãëóïîñò îò SQL Server-à íà ÌÑ. Íà ïðàêòèêà è â òîçè ïðèìåð èìà group by, ìàêàð è íå åêñïëèöèòåí. Çà òàêúâ ñëóæè count ôóíêöèÿòà, àêî ÿ íÿìàøå ùåøå äà îìàæå ñ ãðåøêà: Column 'COLUMN_NAME' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause., èëè íåùî ïîäîäáíî.
Âñå ïàê òîçè ñèíòàêñèñ å íåïðàâèëåí ñïîðåä SQL ñòàíäàðò è ïðè äðóãè ðåàëèçàöèè áè ñúçäàë äîñòà ïðîáëåìè.
Íèêîãà íå áèõ ãî íàïèñàë òàêà, íî è íèêîãà íå áèõ èçïîëçâàë MSSQL Server ïðè ïîëîæåíèå, ÷å ïîëçâàì Oracle è DB2.
-
27th February 2012 12:24 #6Registered User
Join Date: Jul:2001
Location: Ñîôèÿ
Posts: 329
Âñúùíîñò, èçîáùî íå ñòàâà âúïðîñ çà Microsoft SQL Server, à çà äðóãà ÑÓÁÄ - Sybase SQL Anywhere. Âÿðíî, ÷å òÿ å ìîæå áè íàé-áëèçî êàòî ñèíòàêñèñ äî Microsoft SQL Server, íî âñå ïàê å ðàçëè÷íî íåùî.
-
27th February 2012 14:28 #7Registered User
Join Date: Jan:2012
Location: Ñîôèÿ
Posts: 6
Transact-SQL å îáùîòî ìåæäó òÿõ. Îïèñàíèÿ åôåêò å åäèíòè÷åí è ïðè äâåòå ðåàëèçàöèè. Îïðåäåëåíî íå å êàòî plsql è plpgsql ïðè Oracle è PostgreSQL, êúäåòî èìà îïðåäåëåíî âëèÿíèå, íî äâà åçèêà, òî ïðè Transact-SQL èìàìå åäèí ñòàíäàðò.
Ïðàâ ñè, ÷å ðúêîâîäñòâîòî å çà Sybase, ïîäëúãàõ ñå ïî ãîðíèÿ äåñåí úãúë, âñå ïàê òå ñà äîñòà ïî íå ïîïóëÿðíè îò ÌÑ ðåàëèçàöèÿòà.




Reply With Quote

Íå âúçìîæíîñò äà èçêëþ÷à êîìïþòúðà
7th May 2023, 16:02 in Îáù ôîðóì çà PC õàðäóåð