🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #10138

Re: ���һ��SQL�ļ�����

#10138
From: fat man
Date: Mon, 06 Apr 1998 00:00
16 lines
916 bytes
�� �� Roc (Roc) �Ĵ������ᵽ: ��
: thx szshigw
: but My query executed by MSSQL

MSSQL can also use set rowcount,
but it seemed that your own sql query block has 
syntax error.
with group by statement, you should list all
your columes to be selected after your group by 
orelse list them by min/max/count etc. (MSSQL)
SYBASE has no limit at using group by statement


--
�� ��Դ:���������� BBS bbs.nease.net��[FROM: 202.96.179.100]
Technical Details
Message-ID: <3O0RCY$V4V@bbs.nease.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 101948,e68759d7cef2a7bb,start
X-Google-Attributes: gid101948,public
From: szshigw.bbs@bbs.nease.net (fat man)
Subject: Re: ���һ��SQL�ļ�����
Date: 1998/04/06
Message-ID: <3O0RCY$V4V@bbs.nease.net>
X-Deja-AN: 341375953
X-Filename: DataBase/M.891876706.A
Organization: Net Ease
Newsgroups: cn.bbs.comp.database,