SQL Server has no concept of record number. Each record should have a unique ID, typically an auto-increment integer.
Everything in SQL Server is set based (SQL statements). DELETE IN TableName will all the records in the table. I'm not sure why you need to delete everything and append from another table. This isn't usually done in SQL Server.
>hi,
>i've upsized my app to sqlserver 2005
>
>but i can't do some currents operations on tables in sqlserver such as :
>
>1 - replace all
>replace all mytable.field with recno()
>
>2 - update customer's database
>
>loop into all tables in the database
>for each table
>delete all record
>append from another table in other database
>
>i need a sqlserver procedure that can do that
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer