February 28, 2011 at 8:38 am
hi guys,
Can we discuss what are the way,we can check that the consolidated tables were generated correctly?
And i want to clarify ths is nt my hw,i dont know about consolidation ,so i am asking
February 28, 2011 at 9:01 am
daveriya (2/28/2011)
Can we discuss what are the way,we can check that the consolidated tables were generated correctly?
How much do you need to check?
1. Check a table exists with the correct name
2. Check a table exists with the correct name AND has the correct column names, types...
There are a couple of ways to check for a table with a particular name: look in the system view sys.tables, or check if the OBJECT_ID function returns a non-NULL value when given the name as a parameter.
If you need to check more than one table, you will need a loop or join to a table of numbers.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 2 posts - 46 through 46 (of 46 total)
You must be logged in to reply to this topic. Login to reply