Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Delete rows

Author  Topic 

Zertox
Starting Member

2 Posts

Posted - 2002-01-16 : 08:34:43
Is it possible to remove a row with the row nr?

in SQL server enterprise manager i can go to row nr ....

Can I say... I want to delete the 4th row?

if this is possible ... how?


mfemenel
Professor Frink

1421 Posts

Posted - 2002-01-16 : 09:15:03
You can follow the links from this post. It's for selecting nth row, but you can use the same logic for a delete

[url]http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=12095[/url]

Mike
"A program is a device used to convert data into error messages."
Go to Top of Page

Nazim
A custom title

1408 Posts

Posted - 2002-01-16 : 09:38:16
Mike, he wants it from Enterprise Manager....
quote:

in SQL server enterprise manager i can go to row nr ....



----------------------------------
"True love stories don't have endings."

Edited by - Nazim on 01/17/2002 01:05:07
Go to Top of Page

Zertox
Starting Member

2 Posts

Posted - 2002-01-18 : 02:30:43
Actually, i want to do it in VB.net :-)

Go to Top of Page

Nazim
A custom title

1408 Posts

Posted - 2002-01-18 : 05:53:46
you can create a stored procedure and call it using vb.net.

Apart from the link Mike has mentioned, follow this link to u might be able to pick some points.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=11716

HTH

----------------------------------
"True love stories don't have endings."
Go to Top of Page
   

- Advertisement -