Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chinna1214
Starting Member
21 Posts |
 Posted - 2015-01-23 : 00:57:09
|
| Hi,I am working on sql integrating with Hybris. Most of you are not aware of hybris as it was a new technology. In hybris we will create some classes and in those classes we will insert some tables. These tables will be automatically inserted into the sql server. No need to manually insert them the hybris structure will insert it. So my doubt is, how can we find out whether all the records have been inserted into sql database or not how we can check that.Is there any way?? We have those classes in wich we can see which tables are there. Or else from the data model itself we can see what are the tables avilable or shud be inserted into sql thru hybris. Can we check by giving all the table names in a single query?? or is there any other way to find out. If we can check by giving all the table names in single query how we need to give it. Please help me out.Thanks.Harish |
|
|
viggneshwar
Yak Posting Veteran
86 Posts |
Posted - 2015-01-23 : 05:31:31
|
| By using sys.tables we could get all the tables list.In that list you could write dynamic query to do your manipulation with tables.RegardsViggneshwar A |
 |
|
|
|
|
|
How to verify whether all the tables have inserted