Ceník
Druhy
 |
Ajaj, vyskytla se chybaIncorrect syntax near ')'. ======= SQL ======= Select StrId, StrName, StrNameAdd, StrSort, StrType, StrNodesI As [StrNodes], StrSubNodes, Convert(bit, Case When DataLength(StrPict) > 0 Then 1 Else 0 End) As [StrPictHas], StrNote, StrNameE, StrNameAddE, StrWWW, StrWWWNewWin, StrNoteInhNot, StrTag From SPresentTree With (NOLOCK) Where (StrType=0) And (StrHide=0) And (StrHideI=0) And () And (StrHideI=0) And ((StrNodesI>0) Or (StrSubNodes>0)) Order By [StrType], [StrSort]Zdroj: Microsoft OLE DB Provider for SQL Server |