This is exactly what I was looking for 😀 !

The following statement provides all the schemas

CALL ASSP.Discover("DISCOVER_SCHEMA_ROWSETS");

And if any of the schemas is executed then I get schema details

CALL ASSP.Discover("MDSCHEMA_HIERARCHIES");

Thanks...

Well, I went through MSDN Q. & A. on creating indexed views and found the solution... There are two ways to handle this

1. If you want to apply index on...

You can have functioin by passing the EmployeeId and get the required data.

The join provided above is called bulk update where multiple records can be updated as single statement. The...

But I think you will have to include all the columns in join with source to create surrogate key.

So in relational DB PK will not define uniqueness of the data;...

In this particular example SSN can be treated as unique number so there is no need to join on all 5 columns. If you want to transfer this data to...

You can basically create one table defining surrogate key. For example if you have tables like

Region

(idRegion

RegionName

)

and

Country

(idCountry

idRegion

CountryName)

if your composite key in Country is idRegion and CountryName then you can create a...

So does it mean, the index sequence can be decided on any order? Or is there any logic to decide the index ordering?

Will Index (FirstName, LastName) be exactly same as...

I went through a lot of topics by Ralph Kimball and found that primary key is not used in fact table. This is because the fact key will not be...