SSMS script to “Edit Top 200 Rows” for same table across multiple databases

  Kiến thức lập trình

I have about 15 databases with the same table in each (structure, not data) and I have to fill in some data in each depending on what each record says. It’s for about 10 records that can differ in each database and requires human thought for each edit so I can’t automate the process. Is there any way in SSMS or any extensions that offer a way to open the “Edit Top 200 Rows” window via a script that I can run on each database/table combination as opposed to drilling down through the Tables tree for each database?

6

Theme wordpress giá rẻ Theme wordpress giá rẻ Thiết kế website

LEAVE A COMMENT