Quick question

[Karen]

if you want to select top 100 records, you will use

SELECT TOP 100 *
FROM tableName

Is there anyone knows how to find bottom 100 records?

Thanks.

Karen

[Chao Gao]

try :

select top 10 * from tableName order by 1

"Karen" <karen_lau@hotmail.com> wrote in message
news:eUOlicWRDHA.3796@tk2msftngp13.phx.gbl...

> if you want to select top 100 records, you will use
>
> SELECT TOP 100 *
> FROM tableName
>
> Is there anyone knows how to find bottom 100 records?
>
> Thanks.
>
> Karen
>
>

[sender]

In the scenario if you have clustered index on a column of
this table, you can use order by clause (with descending
order) on that column

SELECT TOP 100 *
FROM tableName
ORDER BY clusteredcol DESC

>-----Original Message-----
>if you want to select top 100 records, you will use
>
>SELECT TOP 100 *
>FROM tableName
>
>Is there anyone knows how to find bottom 100 records?
>
>Thanks.
>
>Karen
>
>
>.
>

[Ricky]

User order by descending clause

Select top 100 * from tablename order by fieldname desc

>-----Original Message-----
>if you want to select top 100 records, you will use
>
>SELECT TOP 100 *
>FROM tableName
>
>Is there anyone knows how to find bottom 100 records?
>
>Thanks.
>
>Karen
>
>
>.
>

[Karen]

I want to say thank to all of you. It is really helpful.

Thanks.

Karen

"Karen" <karen_lau@hotmail.com> wrote in message
news:eUOlicWRDHA.3796@tk2msftngp13.phx.gbl...

> if you want to select top 100 records, you will use
>
> SELECT TOP 100 *
> FROM tableName
>
> Is there anyone knows how to find bottom 100 records?
>
> Thanks.
>
> Karen
>
>

[Jorell]

In my asp.net page I am currently showing an XML Document
using the XML Object. What I am trying to accomplish is in
the tags of the XMLDocument adding HTML as Below

<PowerViewXMLDocument>
<Row>
<C001>
Data for row 1<Span style="BACKGROUND-
COLOR: blue">Some Text</Span>
</C001>
</Row>
<Row>
<C001>Data for row 2</C001>
</Row>
...
</PowerViewXMLDocument>

Simply put....trying to color the background of some text
by inserting HTML tags into the XML. Is this possible? Is
there a better way?
Thanks for the help!

Jorell

[Qwip]

how can I count specific charaters in a string?

like the amount of backslashes in-

"D:\Inetpub\site\this\string"



TIA

[Ray at]

sString = "D:\Inetpub\site\this\string"
iNumberOfSlashes = UBound(Split("\" & sString, "\")) - 1

Ray at work


"Qwip" <asdas@emailasdasd.com> wrote in message
news:eh3tqg6gDHA.3784@tk2msftngp13.phx.gbl...

> how can I count specific charaters in a string?
>
> like the amount of backslashes in-
>
> "D:\Inetpub\site\this\string"
>
>
>
> TIA
>
>

[TJS]

[url]http://www.aspin.com/func/search?cob=aspkey&qry=count+characters[/url]


--
================================
[url]http://www.ASPkey.net/[/url]
A Resource Site for Web Developers
*Free OnLine web Tools
*Free development services
================================


"Qwip" <asdas@emailasdasd.com> wrote in message
news:eh3tqg6gDHA.3784@tk2msftngp13.phx.gbl...

> how can I count specific charaters in a string?
>
> like the amount of backslashes in-
>
> "D:\Inetpub\site\this\string"
>
>
>
> TIA
>
>

[Qwip]

Thank you
Thank you


"Qwip" <asdas@emailasdasd.com> wrote in message
news:eh3tqg6gDHA.3784@tk2msftngp13.phx.gbl...

> how can I count specific charaters in a string?
>
> like the amount of backslashes in-
>
> "D:\Inetpub\site\this\string"
>
>
>
> TIA
>
>

[tvr]

Hi,

Is there any command to know which application/program is listening
on a given socket.

For example, some daemons are running on the current system.
I want to know what application is listening on socket 1234.

Is this possible??

Thanks in advance.
tvr1729

[Bit Twister]

On 15 Nov 2003 18:21:06 -0800, tvr wrote:

> Hi,
>
> Is there any command to know which application/program is listening
> on a given socket.
>
> For example, some daemons are running on the current system.
> I want to know what application is listening on socket 1234.
>
> Is this possible??

netstat -ta # maybe

[tvr]

Bit Twister <BitTwister@localhost.localdomain> wrote in message news:<slrnbrdnoi.6ks.BitTwister@wb.home>...

> On 15 Nov 2003 18:21:06 -0800, tvr wrote:

> > Hi,
> >
> > Is there any command to know which application/program is listening
> > on a given socket.
> >
> > For example, some daemons are running on the current system.
> > I want to know what application is listening on socket 1234.
> >
> > Is this possible??

>
>
> netstat -ta # maybe

Nestat displays all the ports...
I want a specific port.

tvr

[Bit Twister]

On 16 Nov 2003 18:20:02 -0800, tvr wrote:

>
> Nestat displays all the ports...
> I want a specific port.

Then pipe it through grep.

[Andrew Jury]

Hi,

Try the open source command 'lsof'. If you don't have it get it here:

[url]http://freshmeat.net/projects/lsof/[/url]

If you are working on Solaris 5.8 > then 'pfiles' is a good choice, however
you will have to filter the output to get the info you need in this case.

--- aj ---

"tvr" <tvr1729@yahoo.com> wrote in message
news:6f4d9f70.0311151821.1cd060bd@posting.google.c om...

> Hi,
>
> Is there any command to know which application/program is listening
> on a given socket.
>
> For example, some daemons are running on the current system.
> I want to know what application is listening on socket 1234.
>
> Is this possible??
>
> Thanks in advance.
> tvr1729

[Ulrich Herbst]

[email]tvr1729@yahoo.com[/email] (tvr) writes:

> Bit Twister <BitTwister@localhost.localdomain> wrote in message news:<slrnbrdnoi.6ks.BitTwister@wb.home>...

> > On 15 Nov 2003 18:21:06 -0800, tvr wrote:

> > > Hi,
> > >
> > > Is there any command to know which application/program is listening
> > > on a given socket.
> > >
> > > For example, some daemons are running on the current system.
> > > I want to know what application is listening on socket 1234.
> > >
> > > Is this possible??

> >
> >
> > netstat -ta # maybe

>
> Nestat displays all the ports...
> I want a specific port.
>

Use netstat -ta | grep xxx

But I think that is different for different Unixes.

For Linux, that is netstat -anp | grep 1234
and you can just list your own processes or you have to be root.

There are some unixes without such a command.

Install and try lsof or fuser.

Uli

--
'''
(0 0)
+------oOO----(_)--------------+
| |
| Ulrich Herbst |
| |
| Tel. ++49-7271-940775 |
| |
| [email]Ulrich.Herbst@gmx.de[/email] |
+-------------------oOO--------+
|__|__|
|| ||
ooO Ooo

[tvr]

Ulrich Herbst <ulrich.herbst@gmx.de> wrote in message news:<877k1zgc2h.fsf@pculi.herbst.fam>...

> [email]tvr1729@yahoo.com[/email] (tvr) writes:
>

> > Bit Twister <BitTwister@localhost.localdomain> wrote in message news:<slrnbrdnoi.6ks.BitTwister@wb.home>...

> > > On 15 Nov 2003 18:21:06 -0800, tvr wrote:
> > > > Hi,
> > > >
> > > > Is there any command to know which application/program is listening
> > > > on a given socket.
> > > >
> > > > For example, some daemons are running on the current system.
> > > > I want to know what application is listening on socket 1234.
> > > >
> > > > Is this possible??
> > >
> > >
> > > netstat -ta # maybe

> >
> > Nestat displays all the ports...
> > I want a specific port.
> >

> Use netstat -ta | grep xxx
>
> But I think that is different for different Unixes.
>
> For Linux, that is netstat -anp | grep 1234
> and you can just list your own processes or you have to be root.
>
> There are some unixes without such a command.
>
> Install and try lsof or fuser.
>
> Uli
>

Guys,

I am familiar with piping and tried that earlier.
Netstat give some stream information
but not the actual process that is listening.

I dont know about others but in solaris it is giving out stream information
for example:

host:~ > netstat -a | grep 8001
3003c3ba8d8 stream-ord 300116d0e50 00000000 8001

So you see, I cant make out what the process is.

Anyway, thanks for the replies
tvr

[Flip]

> So you see, I cant make out what the process is.
I'm a newbie to linux so maybe I'm off the mark here, but I found the -p
returns the name of the program on that port. It seems like you netstat
installed cause you're getting stuff back, what do the man pages say for
programs?

[tvr]

"Flip" <[remove]phenry_w@hotmail.com> wrote in message news:<eP4vb.5658$G1.26726@tor-nn1.netcom.ca>...

> > So you see, I cant make out what the process is.

> I'm a newbie to linux so maybe I'm off the mark here, but I found the -p
> returns the name of the program on that port. It seems like you netstat
> installed cause you're getting stuff back, what do the man pages say for
> programs?

Man pages say,
-p is used to "Show the net to media tables."

Thanks
tvr

[Andy Hibbins]

tvr wrote:

> Man pages say,
> -p is used to "Show the net to media tables."

Have you got lsof? If so this may show what program is using the socket
you mention, "lsof -n -i" may be what you need.

---
Money can't buy happiness, but allows a choice of misery.