I have the below table: IDTableNameFieldName 1tbl1fieldA 1tbl1fieldB 2tbl2fieldC 2tbl2fieldD Th开发者_JAVA技巧e ddl is as under
I want to use sp_msforeachtable to do some work for some tables in a database. I use the IF statement to filter the tables. But it doesn\'t give me the right answer. As the following script shows, I u
Q1: A: There are two tables in a telecom SQL Server database – Customers and Rates as shown below: Customers