and then delete out the entire original table and then insert the
single row back into the table from temp.
On Mon, 16 Aug 2004 15:19:39 -0400, Qasim Rasheed
<[EMAIL PROTECTED]> wrote:
> Hello
>
> I want to delete all records from a table except one (a random one).
> Is there a way to do it? I am using SQL Server
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

