Đang Thực Hiện

127230 MS SQL delete script needed

I have a MS SQL 2005 database with a 100 tables

I want to remove all rows except the first two entries of each table

Example.... delete * from table where rownum less than 2---- i want this done on all 100 tables

Do someone have a MS SQL SCRIPT that i can run for this?

Kỹ năng: Bất kì công việc gì, Thiết lập Bản thảo, SQL

Xem thêm: sql less than, sql script , MS SQL, delete, sql table remove, script sql table, install sql script, install sql, script needed, ms sql sql, delete table sql, sql done, sql delete, delete database table sql, sql 2005, database sql script, database sql 2005, sql 2005 database, delete sql 2005

Về Bên Thuê:
( 44 nhận xét ) United States

Mã Dự Án: #1873398